*----------------------------------------------------------------- * GENERATED APPLICATION: CALLED BATCH *----------------------------------------------------------------- IDENTIFICATION DIVISION. PROGRAM-ID. MGGSM1. AUTHOR. NONE INSTALLATION. NONE DATE WRITTEN. 02.06.2000. DATE COMPILED. ENVIRONMENT DIVISION. CONFIGURATION SECTION. SPECIAL-NAMES. DECIMAL-POINT IS COMMA. *----------------------------------------------------------------- * APPLICATION NAME : MGGSM1 * APPLICATION TYPE : CALLEDBATCH * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:41:03 * GENERATION SYSTEM : MVSCICS * GENERATION DATE : 02.06.2000 * GENERATION TIME : 18:17:47 * GENERATION OPTIONS : * ANSISQL(NO) * CICSDBCS(NO) * COMMLVL(4) * CONTABLE(ELACNTUR) * DATA(31) * DEBUGTRACE(NO) * ENDCOMMAREA(NO) * FOLD(NO) * GENRET(NO) * INEDIT(ALL) * INITADDWS(YES) * INITRECD(YES) * LINEINFO(NO) * MATH(COBOL) * NUMOVFL(YES) * PREPFILE(YES) * PRINTDEST(EZEP) * SPZERO(NO) * SYNCDXFR(YES) * SYSCODES(YES) * TARGNLS(ENU) * TRACE() * TRANSID(DBSV,) * TWAOFF(0) * USERID(DGNM) * VALIDMIX(YES) * WORKDB(AUX) * * PROLOGUE: * *----------------------------------------------------------------- INPUT-OUTPUT SECTION. DATA DIVISION. WORKING-STORAGE SECTION. * RTS APPLICATION PROFILE BLOCK 01 EZEAPP-PROFILE SYNCHRONIZED. 05 FILLER PIC X(8) VALUE "ELARHAPP". 05 EZEAPP-APPL-NAME PIC X(8) VALUE "MGGSM1". 05 EZEAPP-PGM-VERSION. 10 EZEAPP-GEN-DATE PIC X(8) VALUE "20000615". 10 EZEAPP-GEN-TIME PIC X(8) VALUE "18175556". 05 EZEAPP-RTS-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-GEN-VERSION PIC X(16) VALUE "040301". 05 EZEAPP-COB-SYS PIC X(8) VALUE "MVSCICS". 05 EZEAPP-CALLER-PROFILE USAGE IS POINTER VALUE NULL. 05 EZEAPP-EZE-WORDS-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-CURS-BLK-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-DLI-SCAN-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-MSP-IDENT-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-SPA-LEN PIC S9(9) COMP VALUE +0. 05 EZEAPP-MAX-MSG-LEN PIC S9(9) COMP VALUE +0. 05 EZEAPP-WSR-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-DB-IO-LEN PIC S9(9) COMP VALUE +65535. 05 EZEAPP-PARM-VAL-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-1ST-MAP-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-PSBNAME PIC X(8) VALUE SPACES. 05 EZEAPP-PCB-CNT PIC S9(4) COMP VALUE +0. 05 EZEAPP-MS-PCB-NO PIC S9(4) COMP VALUE ZERO. 05 EZEAPP-WK-PCB-NO PIC S9(4) COMP VALUE +0. 05 EZEAPP-ERRDEST PIC X(8) VALUE SPACES. 05 EZEAPP-LOG-ID PIC X(1) VALUE LOW-VALUES. 05 EZEAPP-MSP-PROGRAM PIC X(8) VALUE SPACES. 05 EZEAPP-MAP-GROUP PIC X(8) VALUE SPACES. 05 EZEAPP-HELP-MAP-GROUP PIC X(8) VALUE SPACES. 05 EZEAPP-HELP-PF-KEY PIC X(2) VALUE "01". 05 EZEAPP-BYPASS-PF-KEYS. 10 FILLER PIC X(10) VALUE SPACES. 05 FILLER REDEFINES EZEAPP-BYPASS-PF-KEYS. 10 EZEAPP-BYPASS-PF-KEY PIC X(2) OCCURS 5 TIMES. 05 EZEAPP-MSG-FILE-ID PIC X(4) VALUE SPACES. 05 EZEAPP-MS-DB-TYPE PIC X(1) VALUE "5". 05 EZEAPP-WK-DB-TYPE PIC X(1) VALUE "3". 05 EZEAPP-ADF-SPA PIC X(1) VALUE "N". 05 EZEAPP-APPL-TYPE PIC X(1) VALUE "4". 05 EZEAPP-EXECMODE PIC X(1) VALUE "1". 05 EZEAPP-SCAN-IO-PCB PIC X(1) VALUE "N". 05 EZEAPP-PF1-12-IS-PF13-24 PIC X(1) VALUE "Y". 05 EZEAPP-NLS-CODE PIC X(3) VALUE "ENU". 05 EZEAPP-CURRENCY-SYMBOL PIC X(1) VALUE "T". 05 EZEAPP-DECIMAL-SYMBOL PIC X(1) VALUE ",". 05 EZEAPP-NUM-SEP-SYMBOL PIC X(1) VALUE ".". 05 EZEAPP-MATH PIC X(5) VALUE "COBOL". 05 EZEAPP-SYSTEM-RTN-CODES PIC X(1) VALUE "Y". 05 EZEAPP-ENTRY-FUNCTION PIC X(2) VALUE LOW-VALUES. 05 EZEAPP-MS-RTB-ADDRESS USAGE IS POINTER VALUE NULL. 05 EZEAPP-TBK-STACK-SIZE PIC S9(9) COMP VALUE +0. 05 FILLER PIC X(8) VALUE LOW-VALUES. 05 EZEAPP-FAST-PATH-SW PIC X(1) VALUE "N". 05 EZEAPP-RECOVERY-SW PIC X(1) VALUE "N". 05 FILLER PIC X(1) VALUE LOW-VALUES. 05 EZEAPP-EZEDESTP-CHANGED PIC X(1) VALUE "N". 05 EZEAPP-LINK-TYPE PIC X(1) VALUE "4". 05 EZEAPP-PARM-FORM PIC X(1) VALUE "1". 05 EZEAPP-CURS-BLK-CNT PIC S9(4) COMP VALUE +1. 05 EZEAPP-TWA-LENGTH PIC S9(9) COMP VALUE +0. 05 EZEAPP-TWA-ADDRESS USAGE IS POINTER VALUE NULL. 05 EZEAPP-TWA-USER-LENGTH PIC S9(9) COMP VALUE 0. 05 EZEAPP-MAX-SSA-LENGTH PIC S9(9) COMP VALUE +0. 05 EZEAPP-LTB-ARRAY-ADDRESS USAGE IS POINTER VALUE NULL. 05 EZEAPP-ENTRY-COMMAREA-PTR USAGE IS POINTER VALUE NULLS. 05 FILLER PIC X(1) VALUE SPACES. 05 EZEAPP-NEED-ENDB PIC X(1) VALUE "N". 05 EZEAPP-BAD-RESP PIC X(1) VALUE "N". 05 FILLER PIC X(1) VALUE SPACES. 05 EZEAPP-SYNC-XFERS-SW PIC X(1) VALUE "N". 05 EZEAPP-SYNC-DXFRS-SW PIC X(1) VALUE "Y". 05 EZEAPP-STATIC-CALLS PIC X(1) VALUE "N". 05 EZEAPP-INEDIT-UNP-SW PIC X(1) VALUE "N". 05 EZEAPP-MAX-DB-IOAREA PIC S9(9) COMP VALUE +32767. 05 EZEAPP-LAST-MAPBUF-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-FIRST-MAPBUF-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-ROWS-USED-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-MAPG-MOD-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-HELPG-MOD-PTR USAGE IS POINTER VALUE NULL. 05 EZEAPP-CURRENT-RSCT-IDX PIC S9(9) COMP VALUE +0. 05 EZEAPP-CURRENT-HELP-MAP PIC X(8) VALUE SPACES. 05 EZEAPP-EZEDESTP. 10 EZEDESTP PIC X(65) VALUE SPACES. 05 EZEAPP-OPEN-NEW-DESTP PIC X(1) VALUE "N". 05 EZEAPP-EZEDESTP-DIFF PIC X(1) VALUE "N". 05 EZEAPP-USES-SQL PIC X(1) VALUE "Y". 05 EZEAPP-XFER-MAP PIC X(8) VALUE LOW-VALUES. 05 FILLER PIC X(21) VALUE LOW-VALUES. * RTS ERROR HANDLING REQUEST BLOCK COPY ELAEHERR. * RTS SQL ERROR HANDLING REQUEST BLOCK COPY ELA2HERR. 01 EZECICS-TMP-2BYTE-COMP PIC S9(4) COMP VALUE ZERO. * RTS MNEMONICS COPY ELARHMNE. * RTS REQUEST BLOCK COPY ELARHRRB. * DISPLAY SERVICES REQUEST BLOCK COPY ELARHFMR. * EZE SPECIAL FUNCTION WORDS 01 EZEWORDS. 05 EZEEZE-ID PIC X(8) VALUE "ELARHEZE". 05 EZEWORDS-LL PIC S9(9) COMP VALUE +334. 05 EZEWORDS-I. 10 EZEAID PIC X(2) VALUE SPACES. 88 EZEAID-ENTER VALUE " ". 88 EZEAID-CLEAR VALUE "CL". 88 EZEAID-PAKEY VALUE "P1" "P2" "P3". 88 EZEAID-PA1 VALUE "P1". 88 EZEAID-PA2 VALUE "P2". 88 EZEAID-PA3 VALUE "P3". 10 EZEAID-BYPASS-SW PIC X(1) VALUE SPACES. 88 EZEAID-BYPASS VALUE "Y". 88 EZEAID-NO-BYPASS VALUE "N". 10 EZEAID-HELP-SW PIC X(1) VALUE SPACES. 88 EZEAID-HELP VALUE "Y". 88 EZEAID-NO-HELP VALUE "N". 10 EZEAPP PIC X(8) VALUE SPACES. 10 EZECNVCM PIC 9(1) VALUE 0. 88 EZECNVCM-NOCOMMIT VALUE 0. 88 EZECNVCM-COMMIT VALUE 1. 10 EZEDLTRM REDEFINES EZECNVCM PIC 9(1). 10 FILLER PIC X(5) VALUE LOW-VALUES. 10 EZELOC PIC X(8) VALUE SPACES. 10 EZEDLCER PIC X(2) VALUE "00". 10 EZEDLCON PIC X(2) VALUE "00". 10 FILLER PIC 9(7) VALUE ZEROES. 10 EZEFEC PIC 9(1) VALUE ZEROES. 88 EZEFEC-TERMINATE VALUE 0. 88 EZEFEC-CONTINUE VALUE 1. 10 EZEDLERR PIC 9(1) VALUE ZEROES. 88 EZEDLERR-TERMINATE VALUE 0. 88 EZEDLERR-CONTINUE VALUE 1. 10 EZESQISL PIC 9(1) VALUE ZEROES. 10 EZEMNO PIC S9(4) COMP VALUE ZEROES. 88 EZEMNO-ERROR VALUES 1 THRU 9998 -9999 THRU -1. 88 EZEMNO-NO-ERROR VALUE 0. 88 EZEMNO-RE-CONVERSE VALUE 9999. 10 EZEMNO-MSG-FILE-SW PIC X(1) VALUE "N". 88 EZEMNO-APP-MSG-FILE VALUE "Y". 88 EZEMNO-SYS-MSG-FILE VALUE "N". 10 EZEMSG PIC X(78). 88 EZEMSG-SPACES VALUE SPACES. 10 EZEOVER PIC 9(1) VALUE ZEROES. 88 EZEOVER-DEFAULT VALUE 0. 88 EZEOVER-TERMINATE VALUE 1. 88 EZEOVER-CONTINUE VALUE 2. 10 EZEOVERS PIC 9(1) VALUE ZEROES. 10 EZERCODE PIC S9(9) COMP VALUE ZEROES. 10 EZERT2 PIC X(2) VALUE SPACES. 10 EZERT8. 15 EZERT8FS. 20 EZERT8FH PIC 9(1). 20 EZERT8FL PIC 9(1). 15 EZERT8VS. 20 EZERT8VR PIC 9(2). 20 EZERT8VF PIC 9(1). 20 EZERT8VB PIC 9(3). 10 EZERT8-CICS REDEFINES EZERT8. 15 EZERT8-RESP PIC 9(4). 15 EZERT8-RESP2 PIC 9(4). 10 EZESEGM PIC 9(1) VALUE 0. 88 EZESEGM-NONSEGMENT VALUE 0. 88 EZESEGM-SEGMENTED VALUE 1. 88 EZESEGM-DEFINED VALUE 0. 10 EZECONVT PIC X(8) VALUE SPACES. 10 EZETST PIC S9(4) COMP VALUE ZEROES. 10 EZETST2 PIC S9(4) COMP VALUE ZEROES. 10 EZESQLCA. 15 EZESQNAM PIC X(8) VALUE SPACES. 15 EZESQABC PIC S9(9) COMP VALUE ZEROES. 15 EZESQCOD PIC S9(9) COMP VALUE ZEROES. 15 EZESQRRL PIC S9(4) COMP VALUE ZEROES. 15 EZESQRRM. 20 EZESQRET PIC X OCCURS 70 TIMES INDEXED BY EZESQSUB. 15 EZESQRRP. 20 EZESQRPP PIC X(3) VALUE SPACES. 20 EZESQRVM PIC X(5) VALUE SPACES. 15 EZESQRD1 PIC S9(9) COMP VALUE ZEROES. 15 EZESQRD2 PIC S9(9) COMP VALUE ZEROES. 15 EZESQRD3 PIC S9(9) COMP VALUE ZEROES. 15 EZESQRD4 PIC S9(9) COMP VALUE ZEROES. 15 EZESQRD5 PIC S9(9) COMP VALUE ZEROES. 15 EZESQRD6 PIC S9(9) COMP VALUE ZEROES. 15 FILLER PIC X(1) VALUE SPACES. 15 EZESQWN1 PIC X(1) VALUE SPACES. 15 FILLER PIC X(4) VALUE SPACES. 15 EZESQWN6 PIC X(1) VALUE SPACES. 15 FILLER PIC X(9) VALUE SPACES. 10 EZEDL-PCB-INFO. 15 EZEDLDBD PIC X(8) VALUE SPACES. 15 EZEDLLEV PIC 9(2) VALUE ZEROES. 15 EZEDLSTC PIC X(2) VALUE SPACES. 15 EZEDLPRO PIC X(4) VALUE SPACES. 15 FILLER PIC X(4) VALUE SPACES. 15 EZEDLSEG PIC X(8) VALUE SPACES. 15 EZEDLKYL PIC S9(4) COMP VALUE 1. 15 EZEDLSSG PIC S9(4) COMP VALUE ZEROES. 05 EZEMNO-LOOKED-UP-SW PIC X(1) VALUE "N". 88 EZEMNO-LOOKED-UP VALUE "Y". 88 EZEMNO-NOT-LOOKED-UP VALUE "N". 05 EZESYS PIC X(8) VALUE "MVSCICS". 88 EZESYS-IMSVS VALUE "IMSVS". 88 EZESYS-IMSBMP VALUE "IMSBMP". 88 EZESYS-MVSBATCH VALUE "MVSBATCH". 88 EZESYS-MVSCICS VALUE "MVSCICS". 88 EZESYS-OS2CICS VALUE "OS2CICS". 88 EZESYS-TSO VALUE "TSO". 88 EZESYS-VSECICS VALUE "VSECICS". 88 EZESYS-VSEBATCH VALUE "VSEBATCH". 88 EZESYS-OS400 VALUE "OS400". 88 EZESYS-OS2GUI VALUE "OS2GUI". 88 EZESYS-OS2 VALUE "OS2". 88 EZESYS-AIX VALUE "AIX". 88 EZESYS-WINGUI VALUE "WINGUI". 88 EZESYS-AIXCICS VALUE "AIXCICS". 88 EZESYS-VMCMS VALUE "VMCMS". 88 EZESYS-VMBATCH VALUE "VMBATCH". 88 EZESYS-HP VALUE "HP". 88 EZESYS-ITF VALUE "ITF". 88 EZESYS-NTCICS VALUE "NTCICS". 88 EZESYS-WINNT VALUE "WINNT". 05 FILLER PIC X(2) VALUE LOW-VALUES. 05 EZEDLKEY. 10 EZEDLKYC PIC X(1). * FIXED WORK FIELDS COPY ELARHWRK. 01 EZECTL-CALL-FIELDS. 05 EZECTL-RETURN-CODE PIC S9(4) COMP. 05 EZECTL-INDEX PIC S9(4) COMP. 05 EZECTL-HOLD-EZEDLPSB PIC X(8). 05 EZECTL-HOLD-CTL-MODE PIC X(1). 05 EZECTL-HOLD-CTL-REQUEST PIC X(1). 01 EZECTL-CONTROL-FIELDS. 05 EZECTL-IN-EZETERMINATE-FLAG PIC X(1) VALUE "N". 88 EZECTL-IN-EZETERMINATE VALUE "Y". 88 EZECTL-NOT-IN-EZETERMINATE VALUE "N". 01 EZECTL-FUNCTION-RETURN-CODE. 05 EZECTL-FUNCTION-RC-BIN-2 PIC S9(4) COMP. 05 EZECTL-FUNCTION-RC-BIN-4 PIC S9(9) COMP. 05 EZECTL-FUNCTION-RC-NUM-8 PIC 9(8). *----------------------------------------------------------------- * EXTERNAL PARAMETER CONTROL BLOCK *----------------------------------------------------------------- 01 EZEPARM-VALIDATION. 05 EZEPARM-ID PIC X(8) VALUE "ELARHPRM". 05 EZEPARM-COUNT PIC S9(4) COMP VALUE +3. 05 EZEPARM-TYPES. 10 FILLER PIC X(1) VALUE "4". 10 FILLER PIC X(1) VALUE "4". 10 FILLER PIC X(1) VALUE "4". *----------------------------------------------------------------- * WORKING STORAGE RECORD VDBCOMMON *----------------------------------------------------------------- 01 EZEWS-VDBCOMMON-GP. 02 EZEWS-ID PIC X(8) VALUE "ELAASGWS". 02 EZEWS-VDBCOMMON-LL PIC S9(8) COMP VALUE +158. 02 FILLER PIC X(2) VALUE SPACES. 02 FILLER PIC X(18) VALUE "VDBCOMMON". *----------------------------------------------------------------- * RECORD NAME : VDBCOMMON * FILE ORGANIZATION : WORKSTOR * MODIFICATION DATE : 01.06.2000 * MODIFICATION TIME : 10:48:58 * RECORD PROLOGUE : * ************************************************************ * * Record : VDBCOMMON * * * * Function : Database information and control record * * to be used in the application itself * * ************************************************************ *----------------------------------------------------------------- 02 VDBCOMMON. * General Purpose Index 05 UINDEX1 PIC S9(4) VALUE ZERO USAGE COMP. * General Purpose Index 05 UINDEX2 PIC S9(4) VALUE ZERO USAGE COMP. * General Purpose Index 05 UINDEX3 PIC S9(4) VALUE ZERO USAGE COMP. * Genral Purpose Index 05 UINDEX4 PIC S9(4) VALUE ZERO USAGE COMP. * General Purpose Index 05 UINDEX5 PIC S9(4) VALUE ZERO USAGE COMP. * Last Update Date Timestamp 05 ULAST-UPDATE-TS PIC X(26) VALUE SPACES USAGE DISPLAY. * Application Name 05 UAPPLNAM PIC X(7) VALUE SPACES USAGE DISPLAY. 05 EZE-REDEF-1 REDEFINES UAPPLNAM. * Application Prefix 06 UAPPLPFX PIC X(3) USAGE DISPLAY. 06 EZE-REDEF-2 REDEFINES UAPPLPFX. * Project/System ID - 1st Char 07 USYSID1 PIC X(1) USAGE DISPLAY. * Application ID 07 UAPPLID PIC X(2) USAGE DISPLAY. * Application Suffix 06 UAPPLSFX PIC X(4) USAGE DISPLAY. * Process Name 05 UPROCNAM PIC X(30) VALUE SPACES USAGE DISPLAY. * Table Name 05 UTABLNAM PIC X(30) VALUE SPACES USAGE DISPLAY. * SQL Row Record Name 05 USQLREC PIC X(18) VALUE SPACES USAGE DISPLAY. * NRF Flag 05 UNRF PIC X(1) VALUE SPACES USAGE DISPLAY. * Duplicate Key Flag 05 UDUP PIC X(1) VALUE SPACES USAGE DISPLAY. * SQL Number Item 05 USQLNUM PIC S9(3) VALUE ZERO USAGE DISPLAY. * SQL Code (CHA) 05 UEZESQCD PIC X(4) VALUE SPACES USAGE DISPLAY. 05 EZE-REDEF-3 REDEFINES UEZESQCD. * Number Sign 06 USIGN PIC X(1) USAGE DISPLAY. * SQL Code Insert 06 USQLCHA PIC X(3) USAGE DISPLAY. 02 FILLER PIC X(4) VALUE "*END". EXEC SQL INCLUDE SQLCA END-EXEC. * SQL ITEM REQUEST BLOCK COPY ELASHSQI. *----------------------------------------------------------------- * RECORD NAME = MAAS * TABLE NAME = BORDRO.MAAS * SQL ROW ITEM SQL COLUMN * SICIL SICIL * ESKI_DERECE ESKI_DERECE * ESKI_KADEME ESKI_KADEME * ESKI_EKGOSTERGE ESKI_EKGOSTERGE * ESKI_KIDEM ESKI_KIDEM * DERECE DERECE * KADEME KADEME * EKGOSTERGE EKGOSTERGE * KIDEM KIDEM * IS_GUC_PUAN IS_GUC_PUAN * IS_GUCLUGU IS_GUCLUGU * ELTEM_PUAN ELTEM_PUAN * ELTEM_GUCLUGU ELTEM_GUCLUGU * OZEL_HIZMET_YZD ozel_hizmet_yzd * OZEL_HIZMET_TAZ ozel_hizmet_taz * MAKAM_PUAN MAKAM_PUAN * MAKAM_TAZ MAKAM_TAZ * MALI_SOR_PUAN MALI_SOR_PUAN * MALI_SORUMLULUK_TAZ MALI_SORUMLULUK_TAZ * YABANCI_DIL_SEVIYE YABANCI_DIL_SEVIYE * YABANCI_DIL_TAZ YABANCI_DIL_TAZ * LOJMAN_TAZ LOJMAN_TAZ * AILE_YARDIM_PUAN AILE_YARDIM_PUAN * AILE_YARDIM_TAZ AILE_YARDIM_TAZ * COCUK_SAYI COCUK_SAYI * COCUK_TAZ COCUK_TAZ * GELIR_VERGI GELIR_VERGI * DAMGA_VERGI DAMGA_VERGI * YUKSELIS_KES YUKSELIS_KES * EMEKLI_AIDAT_SAH EMEKLI_AIDAT_SAH * EMEKLI_AIDAT_KUR EMEKLI_AIDAT_KUR * VAKIF_AIDAT VAKIF_AIDAT * SAGLIK_AIDAT SAGLIK_AIDAT * VAKIF_KREDI VAKIF_KREDI * KAMP KAMP * YEMEK YEMEK * LOKAL LOKAL * KRES KRES * ICRA ICRA * HARCIRAH HARCIRAH * NET_MAAS NET_MAAS * TOP_MATRAH TOP_MATRAH *----------------------------------------------------------------- 01 EZESTA-MAAS-GP. 02 EZESTA-ID PIC X(8) VALUE "ELAASGSR". 02 EZESTA-MAAS-LL PIC S9(8) COMP VALUE +422. 02 EZESTA-MAAS-RC PIC S9(2) VALUE 00. 88 EZESTA-MAAS-OK VALUE 00. 88 EZESTA-MAAS-ERR VALUES ARE -99 THRU -01 01 THRU 99. 88 EZESTA-MAAS-SFT VALUES ARE 01 THRU 99. 88 EZESTA-MAAS-DED VALUE -01. 88 EZESTA-MAAS-DUP VALUE -05. 88 EZESTA-MAAS-EOF VALUE 03 07. 88 EZESTA-MAAS-NRF VALUE 04 07. 88 EZESTA-MAAS-UNQ VALUE -05. 88 EZESTA-MAAS-HRD VALUES ARE -99 THRU -01. 88 EZESTA-MAAS-FUL VALUE -06. 88 EZESTA-MAAS-FNA VALUE -07. 88 EZESTA-MAAS-FMT VALUE -08. 88 EZESTA-MAAS-FNF VALUE -09. 88 EZESTA-MAAS-LOK VALUE -10. 02 FILLER PIC X(18) VALUE "MAAS". *----------------------------------------------------------------- * RECORD NAME : MAAS * FILE ORGANIZATION : SQLROW * RECORD KEY : SICIL * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 18:25:01 * RECORD PROLOGUE : * *----------------------------------------------------------------- 02 MAAS. 10 FILLER PIC X(4). 10 SICIL PIC X(5) USAGE DISPLAY. 10 FILLER PIC X(4). * ESKI_DERECE WAS RENAMED TO EZEI-1 10 EZEI-1 PIC X(2) USAGE DISPLAY. 10 FILLER PIC X(4). * ESKI_KADEME WAS RENAMED TO EZEI-2 10 EZEI-2 PIC X(1) USAGE DISPLAY. 10 FILLER PIC X(4). * ESKI_EKGOSTERGE WAS RENAMED TO EZEI-3 10 EZEI-3 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). * ESKI_KIDEM WAS RENAMED TO EZEI-4 10 EZEI-4 PIC S9(4) USAGE COMP. 10 FILLER PIC X(4). 10 DERECE PIC X(2) USAGE DISPLAY. 10 FILLER PIC X(4). 10 KADEME PIC X(1) USAGE DISPLAY. 10 FILLER PIC X(4). 10 EKGOSTERGE PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 KIDEM PIC S9(4) USAGE COMP. 10 FILLER PIC X(4). * IS_GUC_PUAN WAS RENAMED TO EZEI-5 10 EZEI-5 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). * IS_GUCLUGU WAS RENAMED TO EZEI-6 10 EZEI-6 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * ELTEM_PUAN WAS RENAMED TO EZEI-7 10 EZEI-7 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). * ELTEM_GUCLUGU WAS RENAMED TO EZEI-8 10 EZEI-8 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * ozel_hizmet_yzd WAS RENAMED TO EZEI-9 10 EZEI-9 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). * ozel_hizmet_taz WAS RENAMED TO EZEI-10 10 EZEI-10 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * MAKAM_PUAN WAS RENAMED TO EZEI-11 10 EZEI-11 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). * MAKAM_TAZ WAS RENAMED TO EZEI-12 10 EZEI-12 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * MALI_SOR_PUAN WAS RENAMED TO EZEI-13 10 EZEI-13 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). * MALI_SORUMLULUK_TAZ WAS RENAMED TO EZEI-14 10 EZEI-14 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * YABANCI_DIL_SEVIYE WAS RENAMED TO EZEI-15 10 EZEI-15 PIC X(1) USAGE DISPLAY. 10 FILLER PIC X(4). * YABANCI_DIL_TAZ WAS RENAMED TO EZEI-16 10 EZEI-16 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * LOJMAN_TAZ WAS RENAMED TO EZEI-17 10 EZEI-17 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * AILE_YARDIM_PUAN WAS RENAMED TO EZEI-18 10 EZEI-18 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). * AILE_YARDIM_TAZ WAS RENAMED TO EZEI-19 10 EZEI-19 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * COCUK_SAYI WAS RENAMED TO EZEI-20 10 EZEI-20 PIC S9(4) USAGE COMP. 10 FILLER PIC X(4). * COCUK_TAZ WAS RENAMED TO EZEI-21 10 EZEI-21 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * GELIR_VERGI WAS RENAMED TO EZEI-22 10 EZEI-22 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * DAMGA_VERGI WAS RENAMED TO EZEI-23 10 EZEI-23 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * YUKSELIS_KES WAS RENAMED TO EZEI-24 10 EZEI-24 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * EMEKLI_AIDAT_SAH WAS RENAMED TO EZEI-25 10 EZEI-25 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * EMEKLI_AIDAT_KUR WAS RENAMED TO EZEI-26 10 EZEI-26 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * VAKIF_AIDAT WAS RENAMED TO EZEI-27 10 EZEI-27 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * SAGLIK_AIDAT WAS RENAMED TO EZEI-28 10 EZEI-28 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * VAKIF_KREDI WAS RENAMED TO EZEI-29 10 EZEI-29 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 KAMP PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 YEMEK PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 LOKAL PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 KRES PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 ICRA PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 HARCIRAH PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * NET_MAAS WAS RENAMED TO EZEI-30 10 EZEI-30 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). * TOP_MATRAH WAS RENAMED TO EZEI-31 10 EZEI-31 PIC S9(15) USAGE COMP-3. 02 EZESQL-MAAS-H REDEFINES MAAS. 10 FILLER PIC X(4). 10 SICIL PIC X(5) USAGE DISPLAY. 10 FILLER PIC X(4). 10 EZEI-1 PIC X(2) USAGE DISPLAY. 10 FILLER PIC X(4). 10 EZEI-2 PIC X(1) USAGE DISPLAY. 10 FILLER PIC X(4). 10 EZEI-3 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-4 PIC S9(4) USAGE COMP. 10 FILLER PIC X(4). 10 DERECE PIC X(2) USAGE DISPLAY. 10 FILLER PIC X(4). 10 KADEME PIC X(1) USAGE DISPLAY. 10 FILLER PIC X(4). 10 EKGOSTERGE PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 KIDEM PIC S9(4) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-5 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-6 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-7 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-8 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-9 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-10 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-11 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-12 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-13 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-14 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-15 PIC X(1) USAGE DISPLAY. 10 FILLER PIC X(4). 10 EZEI-16 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-17 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-18 PIC S9(9) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-19 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-20 PIC S9(4) USAGE COMP. 10 FILLER PIC X(4). 10 EZEI-21 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-22 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-23 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-24 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-25 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-26 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-27 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-28 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-29 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 KAMP PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 YEMEK PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 LOKAL PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 KRES PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 ICRA PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 HARCIRAH PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-30 PIC S9(13) USAGE COMP-3. 10 FILLER PIC X(4). 10 EZEI-31 PIC S9(15) USAGE COMP-3. 02 EZESQL-MAAS-I REDEFINES MAAS. 10 SICIL PIC S9(4) COMP. 10 FILLER PIC X(7). 10 EZEI-1 PIC S9(4) COMP. 10 FILLER PIC X(4). 10 EZEI-2 PIC S9(4) COMP. 10 FILLER PIC X(3). 10 EZEI-3 PIC S9(4) COMP. 10 FILLER PIC X(6). 10 EZEI-4 PIC S9(4) COMP. 10 FILLER PIC X(4). 10 DERECE PIC S9(4) COMP. 10 FILLER PIC X(4). 10 KADEME PIC S9(4) COMP. 10 FILLER PIC X(3). 10 EKGOSTERGE PIC S9(4) COMP. 10 FILLER PIC X(6). 10 KIDEM PIC S9(4) COMP. 10 FILLER PIC X(4). 10 EZEI-5 PIC S9(4) COMP. 10 FILLER PIC X(6). 10 EZEI-6 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-7 PIC S9(4) COMP. 10 FILLER PIC X(6). 10 EZEI-8 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-9 PIC S9(4) COMP. 10 FILLER PIC X(6). 10 EZEI-10 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-11 PIC S9(4) COMP. 10 FILLER PIC X(6). 10 EZEI-12 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-13 PIC S9(4) COMP. 10 FILLER PIC X(6). 10 EZEI-14 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-15 PIC S9(4) COMP. 10 FILLER PIC X(3). 10 EZEI-16 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-17 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-18 PIC S9(4) COMP. 10 FILLER PIC X(6). 10 EZEI-19 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-20 PIC S9(4) COMP. 10 FILLER PIC X(4). 10 EZEI-21 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-22 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-23 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-24 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-25 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-26 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-27 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-28 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-29 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 KAMP PIC S9(4) COMP. 10 FILLER PIC X(9). 10 YEMEK PIC S9(4) COMP. 10 FILLER PIC X(9). 10 LOKAL PIC S9(4) COMP. 10 FILLER PIC X(9). 10 KRES PIC S9(4) COMP. 10 FILLER PIC X(9). 10 ICRA PIC S9(4) COMP. 10 FILLER PIC X(9). 10 HARCIRAH PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-30 PIC S9(4) COMP. 10 FILLER PIC X(9). 10 EZEI-31 PIC S9(4) COMP. 10 FILLER PIC X(10). 02 FILLER PIC X(4) VALUE "*END". LINKAGE SECTION. 01 DFHCOMMAREA. 05 EZECOMMAREA PIC X(32763). 05 EZECOMMAREA-MAPPED REDEFINES EZECOMMAREA. 10 EZECOMMAREA-SSM-STATUS PIC X. 10 EZECOMMAREA-MAP-NAME PIC X(8). 10 EZECOMMAREA-RESERVED-0 PIC X. 10 EZECOMMAREA-USER-AREA PIC X(32753). 05 EZECOMMAREA-POINTERS REDEFINES EZECOMMAREA. 10 EZECOMMAREA-PTR USAGE IS POINTER OCCURS 8190 TIMES. 10 EZECOMMAREA-PTR-RSVD PIC X(3). * RTS CONTROL BLOCK COPY ELARHRTS REPLACING ==SYNCHRONIZED EXTERNAL== BY ==SYNCHRONIZED==. * RTS NLS-DEPENDENT INSTALLATION OPTIONS CONTROL BLOCK COPY ELARHIOE. * RTS NLS-INDEPENDENT INSTALLATION OPTIONS CONTROL BLOCK COPY ELARHIOP. * RESOURCE CONTROL BLOCK COPY ELARHRSC. * STATIC CONTROL BLOCK COPY ELARHSCB. *----------------------------------------------------------------- * RECORD NAME : WMAAS * FILE ORGANIZATION : WORKSTOR * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 14:36:19 * RECORD PROLOGUE : * *----------------------------------------------------------------- 01 EZERCD-WMAAS-GP. 02 WMAAS. 05 SICIL PIC X(5) USAGE DISPLAY. * ESKI_DERECE WAS RENAMED TO ESKI-DERECE 05 ESKI-DERECE PIC X(2) USAGE DISPLAY. * ESKI_KADEME WAS RENAMED TO ESKI-KADEME 05 ESKI-KADEME PIC X(1) USAGE DISPLAY. * ESKI_EKGOSTERGE WAS RENAMED TO ESKI-EKGOSTERGE 05 ESKI-EKGOSTERGE PIC S9(9) USAGE COMP. * ESKI_KIDEM WAS RENAMED TO ESKI-KIDEM 05 ESKI-KIDEM PIC S9(4) USAGE COMP. 05 DERECE PIC X(2) USAGE DISPLAY. 05 KADEME PIC X(1) USAGE DISPLAY. 05 EKGOSTERGE PIC S9(9) USAGE COMP. 05 KIDEM PIC S9(4) USAGE COMP. * IS_GUC_PUAN WAS RENAMED TO IS-GUC-PUAN 05 IS-GUC-PUAN PIC S9(9) USAGE COMP. * IS_GUCLUGU WAS RENAMED TO IS-GUCLUGU 05 IS-GUCLUGU PIC S9(13) USAGE COMP-3. * ELTEM_PUAN WAS RENAMED TO ELTEM-PUAN 05 ELTEM-PUAN PIC S9(9) USAGE COMP. * ELTEM_GUCLUGU WAS RENAMED TO ELTEM-GUCLUGU 05 ELTEM-GUCLUGU PIC S9(13) USAGE COMP-3. * OZEL_HIZMET_YZD WAS RENAMED TO OZEL-HIZMET-YZD 05 OZEL-HIZMET-YZD PIC S9(9) USAGE COMP. * OZEL_HIZMET_TAZ WAS RENAMED TO OZEL-HIZMET-TAZ 05 OZEL-HIZMET-TAZ PIC S9(13) USAGE COMP-3. * MAKAM_PUAN WAS RENAMED TO MAKAM-PUAN 05 MAKAM-PUAN PIC S9(9) USAGE COMP. * MAKAM_TAZ WAS RENAMED TO MAKAM-TAZ 05 MAKAM-TAZ PIC S9(13) USAGE COMP-3. * MALI_SOR_PUAN WAS RENAMED TO MALI-SOR-PUAN 05 MALI-SOR-PUAN PIC S9(9) USAGE COMP. * MALI_SORUMLULUK_TAZ WAS RENAMED TO MALI-SORUMLULUK-TAZ 05 MALI-SORUMLULUK-TAZ PIC S9(13) USAGE COMP-3. * YABANCI_DIL_SEVIYE WAS RENAMED TO YABANCI-DIL-SEVIYE 05 YABANCI-DIL-SEVIYE PIC X(1) USAGE DISPLAY. * YABANCI_DIL_TAZ WAS RENAMED TO YABANCI-DIL-TAZ 05 YABANCI-DIL-TAZ PIC S9(13) USAGE COMP-3. * LOJMAN_TAZ WAS RENAMED TO LOJMAN-TAZ 05 LOJMAN-TAZ PIC S9(13) USAGE COMP-3. * AILE_YARDIM_PUAN WAS RENAMED TO AILE-YARDIM-PUAN 05 AILE-YARDIM-PUAN PIC S9(9) USAGE COMP. * AILE_YARDIM_TAZ WAS RENAMED TO AILE-YARDIM-TAZ 05 AILE-YARDIM-TAZ PIC S9(13) USAGE COMP-3. * COCUK_SAYI WAS RENAMED TO COCUK-SAYI 05 COCUK-SAYI PIC S9(4) USAGE COMP. * COCUK_TAZ WAS RENAMED TO COCUK-TAZ 05 COCUK-TAZ PIC S9(13) USAGE COMP-3. * GELIR_VERGI WAS RENAMED TO GELIR-VERGI 05 GELIR-VERGI PIC S9(13) USAGE COMP-3. * DAMGA_VERGI WAS RENAMED TO DAMGA-VERGI 05 DAMGA-VERGI PIC S9(13) USAGE COMP-3. * YUKSELIS_KES WAS RENAMED TO YUKSELIS-KES 05 YUKSELIS-KES PIC S9(13) USAGE COMP-3. * EMEKLI_AIDAT_SAH WAS RENAMED TO EMEKLI-AIDAT-SAH 05 EMEKLI-AIDAT-SAH PIC S9(13) USAGE COMP-3. * EMEKLI_AIDAT_KUR WAS RENAMED TO EMEKLI-AIDAT-KUR 05 EMEKLI-AIDAT-KUR PIC S9(13) USAGE COMP-3. * VAKIF_AIDAT WAS RENAMED TO VAKIF-AIDAT 05 VAKIF-AIDAT PIC S9(13) USAGE COMP-3. * SAGLIK_AIDAT WAS RENAMED TO SAGLIK-AIDAT 05 SAGLIK-AIDAT PIC S9(13) USAGE COMP-3. * VAKIF_KREDI WAS RENAMED TO VAKIF-KREDI 05 VAKIF-KREDI PIC S9(13) USAGE COMP-3. 05 KAMP PIC S9(13) USAGE COMP-3. 05 YEMEK PIC S9(13) USAGE COMP-3. 05 LOKAL PIC S9(13) USAGE COMP-3. 05 KRES PIC S9(13) USAGE COMP-3. 05 ICRA PIC S9(13) USAGE COMP-3. 05 HARCIRAH PIC S9(13) USAGE COMP-3. * NET_MAAS WAS RENAMED TO NET-MAAS 05 NET-MAAS PIC S9(13) USAGE COMP-3. * TOP_MATRAH WAS RENAMED TO TOP-MATRAH 05 TOP-MATRAH PIC S9(15) USAGE COMP-3. *----------------------------------------------------------------- * RECORD NAME : VDBCONTROL * FILE ORGANIZATION : WORKSTOR * MODIFICATION DATE : 01.06.2000 * MODIFICATION TIME : 10:49:21 * RECORD PROLOGUE : * ************************************************************ * * Record : VDBCONTROL * * * * Function : Database and control information to pass * * between umbrella and atomic server * * applications. * * ************************************************************ *----------------------------------------------------------------- 01 EZERCD-VDBCONTROL-GP. 02 VDBCONTROL. * Database Control Record Item 05 UDBCONTROL PIC X(74) USAGE DISPLAY. 05 EZE-REDEF-4 REDEFINES UDBCONTROL. * Return Code (CHA) 06 URCCHAR PIC X(3) USAGE DISPLAY. 06 EZE-REDEF-5 REDEFINES URCCHAR. * Return Code 07 URC PIC S9(3) USAGE DISPLAY. * Rollback Required Flag 06 UROLLBACK PIC X(1) USAGE DISPLAY. * Error Message Inserts from SQL 06 UEZESQRRM PIC X(70) USAGE DISPLAY. * Database Local Area 05 UDBLOCAL PIC X(11) USAGE DISPLAY. 05 EZE-REDEF-6 REDEFINES UDBLOCAL. * SQL Access Type 06 UACCTYP PIC X(1) USAGE DISPLAY. * Access Type Save 06 UACCSAV PIC X(1) USAGE DISPLAY. * Rows Read Counter 06 UROWR PIC S9(9) USAGE COMP. * Rows Written Counter 06 UROWW PIC S9(9) USAGE COMP. * Req. I/O (ISUD) or List (LFB) 06 UIOTYPE PIC X(1) USAGE DISPLAY. * NRF Flag 05 UNRF PIC X(1) USAGE DISPLAY. * HIGH-VALUE WAS RENAMED TO EZEI-HIGH-VALUE 05 EZEI-HIGH-VALUE PIC X(1) USAGE DISPLAY. 05 EZE-REDEF-7 REDEFINES EZEI-HIGH-VALUE. 06 HIGH-VALUE-HEX PIC X(1) USAGE DISPLAY. * LOW-VALUE WAS RENAMED TO EZEI-LOW-VALUE 05 EZEI-LOW-VALUE PIC X(1) USAGE DISPLAY. 05 EZE-REDEF-8 REDEFINES EZEI-LOW-VALUE. 06 LOW-VALUE-HEX PIC X(1) USAGE DISPLAY. * HIGH-VALUES WAS RENAMED TO EZEI-HIGH-VALUES 05 EZEI-HIGH-VALUES PIC X(100) USAGE DISPLAY. 05 EZE-REDEF-9 REDEFINES EZEI-HIGH-VALUES. 06 HIGH-VALUES-CHAR PIC X(1) OCCURS 100 INDEXED BY EZEIDX1 USAGE DISPLAY. * LOW-VALUES WAS RENAMED TO EZEI-LOW-VALUES 05 EZEI-LOW-VALUES PIC X(100) USAGE DISPLAY. 05 EZE-REDEF-10 REDEFINES EZEI-LOW-VALUES. 06 LOW-VALUES-CHAR PIC X(1) OCCURS 100 INDEXED BY EZEIDX2 USAGE DISPLAY. *----------------------------------------------------------------- * RECORD NAME : VMESSAGE * FILE ORGANIZATION : WORKSTOR * MODIFICATION DATE : 01.06.2000 * MODIFICATION TIME : 10:49:43 * RECORD PROLOGUE : * ************************************************************ * * Record : VMESSAGE * * * * Function : Message record. * * * ************************************************************ *----------------------------------------------------------------- 01 EZERCD-VMESSAGE-GP. 02 VMESSAGE. 05 UMSGCONTROL PIC X(224) USAGE DISPLAY. 05 EZE-REDEF-11 REDEFINES UMSGCONTROL. * Message Code 06 UMSGCODE PIC X(8) USAGE DISPLAY. * Message Insert 06 UMSGINS PIC X(30) OCCURS 3 INDEXED BY EZEIDX3 USAGE DISPLAY. * Message Text 06 UMESSAGE PIC X(125) USAGE DISPLAY. * Message Type 06 UMSGTYPE PIC X(1) USAGE DISPLAY. EXEC SQL DECLARE EZE001001MGGSM1 CURSOR FOR SELECT ESKI_DERECE , ESKI_KADEME , ESKI_EKGOSTERGE , ESKI_KIDEM , DERECE , KADEME , EKGOSTERGE , KIDEM , IS_GUC_PUAN , IS_GUCLUGU , ELTEM_PUAN , ELTEM_GUCLUGU , ELTEM_PUAN , ELTEM_GUCLUGU , MAKAM_PUAN , MAKAM_TAZ , MALI_SOR_PUAN , MALI_SORUMLULUK_TAZ , YABANCI_DIL_SEVIYE , YABANCI_DIL_TAZ , LOJMAN_TAZ , AILE_YARDIM_PUAN , AILE_YARDIM_TAZ , COCUK_SAYI , COCUK_TAZ , GELIR_VERGI , DAMGA_VERGI , YUKSELIS_KES , EMEKLI_AIDAT_SAH , EMEKLI_AIDAT_KUR , VAKIF_AIDAT , SAGLIK_AIDAT , VAKIF_KREDI , KAMP , YEMEK , LOKAL , KRES , ICRA , HARCIRAH , NET_MAAS , TOP_MATRAH FROM BORDRO.MAAS T1 WHERE SICIL = :EZESQL-MAAS-H.SICIL:EZESQL-MAAS-I.SICIL FOR UPDATE OF SICIL , ESKI_DERECE , ESKI_KADEME , ESKI_EKGOSTERGE , ESKI_KIDEM , DERECE , KADEME , EKGOSTERGE , KIDEM , IS_GUC_PUAN , IS_GUCLUGU , ELTEM_PUAN , ELTEM_GUCLUGU , ELTEM_PUAN , ELTEM_GUCLUGU , MAKAM_PUAN , MAKAM_TAZ , MALI_SOR_PUAN , MALI_SORUMLULUK_TAZ , YABANCI_DIL_SEVIYE , YABANCI_DIL_TAZ , LOJMAN_TAZ , AILE_YARDIM_PUAN , AILE_YARDIM_TAZ , COCUK_SAYI , COCUK_TAZ , VAKIF_AIDAT , SAGLIK_AIDAT , VAKIF_KREDI , KAMP , YEMEK , LOKAL , KRES , ICRA , HARCIRAH END-EXEC. *----------------------------------------------------------------- * SQL CURSOR CONTROL BLOCKS *----------------------------------------------------------------- 01 EZECRS-CURSOR-BLOCKS. 02 EZECRS-ID PIC X(8). 02 EZECRS-CNT PIC S9(4) COMP. *----------------------------------------------------------------- * CURSOR CONTROL BLOCK FOR SQL ROW MAAS *----------------------------------------------------------------- 02 EZECRS-MAAS-CB. 05 EZECRS-MAAS-TYP PIC X(4). 88 EZECRS-MAAS-SETI VALUE "SETI". 88 EZECRS-MAAS-SETU VALUE "SETU". 88 EZECRS-MAAS-SIWH VALUE "SIWH". 88 EZECRS-MAAS-SUWH VALUE "SUWH". 88 EZECRS-MAAS-UPDT VALUE "UPDT". 88 EZECRS-MAAS-INQU VALUE "INQU". 05 EZECRS-MAAS-ID PIC S9(4) COMP. 88 EZECRS-MAAS-CLOS VALUE 0. PROCEDURE DIVISION. *----------------------------------------------------------------- * MAIN PROCESS *----------------------------------------------------------------- EZEMAIN-PROCESS SECTION. PERFORM EZECONTROL GOBACK. *----------------------------------------------------------------- * BEGIN PROCESS *----------------------------------------------------------------- EZEBEGIN-PROCESSES SECTION. CONTINUE. *----------------------------------------------------------------- * SQL PROCESS OPTIONS BYPASS *----------------------------------------------------------------- EZESQL-PROCESS-BYPASS SECTION. GO TO MGGSM1-MAIN. EZESQL-PROCESS-BYPASS-X. EXIT. *----------------------------------------------------------------- * SQL PROCESS OPTIONS * * SQL CLOSE CURSOR AND PROCESS OPTIONS SECTIONS ARE PLACED AT THE * TOP OF THE PROGRAM. * THE SQL PREPROCESSOR DOES NOT PROCESS EXEC SQL STATEMENTS AFTER * 32,767. *----------------------------------------------------------------- *----------------------------------------------------------------- * CLOSE CURSOR FOR SQL ROW MAAS *----------------------------------------------------------------- EZECLOSCU-MAAS SECTION. MOVE SPACES TO EZECRS-MAAS-TYP IF EZECRS-MAAS-CLOS GO TO EZECLOSCU-MAAS-X END-IF IF EZECRS-MAAS-ID = 1 EXEC SQL CLOSE EZE001001MGGSM1 END-EXEC END-IF SET EZECRS-MAAS-CLOS TO TRUE MOVE "CLOSE" TO EZERTS-SQL-COMMAND PERFORM EZESQL-ERROR-ROUTINE IF EZERTS-PRC-OPT = "CLOSE" OR (SQLCODE NOT = 0 AND EZESQCOD = 0) MOVE SQLCA TO EZESQLCA MOVE EZERTS-SQLERR-STATUS TO EZESTA-MAAS-RC END-IF. EZECLOSCU-MAAS-X. EXIT. *----------------------------------------------------------------- * INPUT / OUTPUT ROUTINE FOR PROCESS MAAS-DEL *----------------------------------------------------------------- * PROCESS OPTION : DELETE * PROCESS OBJECT : MAAS *----------------------------------------------------------------- EZEDELT-MAAS-DEL SECTION. MOVE "MAAS-DEL" TO EZERTS-PRC-NAME MOVE "DELETE" TO EZERTS-PRC-OPT MOVE "MAAS" TO EZERTS-PRC-OBJ SET EZERTS-NO-ERROR-ROUTINE TO TRUE MOVE ZEROES TO EZESTA-MAAS-RC IF EZECRS-MAAS-CLOS OR EZECRS-MAAS-SETI OR EZECRS-MAAS-SIWH MOVE 0086 TO EZERTS-ERROR-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-ERROR-REQUEST-BLOCK GO TO EZETERMINATE END-IF IF EZECRS-MAAS-ID = 1 EXEC SQL DELETE FROM BORDRO.MAAS WHERE CURRENT OF EZE001001MGGSM1 END-EXEC END-IF MOVE "DELETE" TO EZERTS-SQL-COMMAND PERFORM EZESQL-ERROR-ROUTINE MOVE EZERTS-SQLERR-STATUS TO EZESTA-MAAS-RC IF EZECRS-MAAS-UPDT PERFORM EZECLOSCU-MAAS END-IF. EZEDEL-MAAS-DEL-ERR. IF EZESTA-MAAS-ERR SET EZERTS-EZECLOS TO TRUE GO TO EZETERMINATE END-IF CONTINUE. EZEDELT-MAAS-DEL-X. EXIT. *----------------------------------------------------------------- * INPUT / OUTPUT ROUTINE FOR PROCESS MAAS_ADD *----------------------------------------------------------------- * PROCESS OPTION : ADD * PROCESS OBJECT : MAAS *----------------------------------------------------------------- EZEADD-MAAS-ADD SECTION. MOVE "MAAS_ADD" TO EZERTS-PRC-NAME MOVE "ADD" TO EZERTS-PRC-OPT MOVE "MAAS" TO EZERTS-PRC-OBJ SET EZERTS-NO-ERROR-ROUTINE TO TRUE MOVE ZEROES TO EZESTA-MAAS-RC EXEC SQL INSERT INTO BORDRO.MAAS (SICIL , ESKI_DERECE , ESKI_KADEME , ESKI_EKGOSTERGE , ESKI_KIDEM , DERECE , KADEME , EKGOSTERGE , KIDEM , IS_GUC_PUAN , IS_GUCLUGU , ELTEM_PUAN , ELTEM_GUCLUGU , OZEL_HIZMET_YZD , OZEL_HIZMET_TAZ , MAKAM_PUAN , MAKAM_TAZ , MALI_SOR_PUAN , MALI_SORUMLULUK_TAZ , YABANCI_DIL_SEVIYE , YABANCI_DIL_TAZ , LOJMAN_TAZ , AILE_YARDIM_PUAN , AILE_YARDIM_TAZ , COCUK_SAYI , COCUK_TAZ , GELIR_VERGI , DAMGA_VERGI , YUKSELIS_KES , EMEKLI_AIDAT_SAH , EMEKLI_AIDAT_KUR , VAKIF_AIDAT , SAGLIK_AIDAT , VAKIF_KREDI , KAMP , YEMEK , LOKAL , KRES , ICRA , HARCIRAH , NET_MAAS , TOP_MATRAH ) VALUES (:EZESQL-MAAS-H.SICIL:EZESQL-MAAS-I.SICIL , :EZESQL-MAAS-H.EZEI-1:EZESQL-MAAS-I.EZEI-1 , :EZESQL-MAAS-H.EZEI-2:EZESQL-MAAS-I.EZEI-2 , :EZESQL-MAAS-H.EZEI-3:EZESQL-MAAS-I.EZEI-3 , :EZESQL-MAAS-H.EZEI-4:EZESQL-MAAS-I.EZEI-4 , :EZESQL-MAAS-H.DERECE:EZESQL-MAAS-I.DERECE , :EZESQL-MAAS-H.KADEME:EZESQL-MAAS-I.KADEME , :EZESQL-MAAS-H.EKGOSTERGE:EZESQL-MAAS-I.EKGOSTERGE , :EZESQL-MAAS-H.KIDEM:EZESQL-MAAS-I.KIDEM , :EZESQL-MAAS-H.EZEI-5:EZESQL-MAAS-I.EZEI-5 , :EZESQL-MAAS-H.EZEI-6:EZESQL-MAAS-I.EZEI-6 , :EZESQL-MAAS-H.EZEI-7:EZESQL-MAAS-I.EZEI-7 , :EZESQL-MAAS-H.EZEI-8:EZESQL-MAAS-I.EZEI-8 , :EZESQL-MAAS-H.EZEI-9:EZESQL-MAAS-I.EZEI-9 , :EZESQL-MAAS-H.EZEI-10:EZESQL-MAAS-I.EZEI-10 , :EZESQL-MAAS-H.EZEI-11:EZESQL-MAAS-I.EZEI-11 , :EZESQL-MAAS-H.EZEI-12:EZESQL-MAAS-I.EZEI-12 , :EZESQL-MAAS-H.EZEI-13:EZESQL-MAAS-I.EZEI-13 , :EZESQL-MAAS-H.EZEI-14:EZESQL-MAAS-I.EZEI-14 , :EZESQL-MAAS-H.EZEI-15:EZESQL-MAAS-I.EZEI-15 , :EZESQL-MAAS-H.EZEI-16:EZESQL-MAAS-I.EZEI-16 , :EZESQL-MAAS-H.EZEI-17:EZESQL-MAAS-I.EZEI-17 , :EZESQL-MAAS-H.EZEI-18:EZESQL-MAAS-I.EZEI-18 , :EZESQL-MAAS-H.EZEI-19:EZESQL-MAAS-I.EZEI-19 , :EZESQL-MAAS-H.EZEI-20:EZESQL-MAAS-I.EZEI-20 , :EZESQL-MAAS-H.EZEI-21:EZESQL-MAAS-I.EZEI-21 , :EZESQL-MAAS-H.EZEI-22:EZESQL-MAAS-I.EZEI-22 , :EZESQL-MAAS-H.EZEI-23:EZESQL-MAAS-I.EZEI-23 , :EZESQL-MAAS-H.EZEI-24:EZESQL-MAAS-I.EZEI-24 , :EZESQL-MAAS-H.EZEI-25:EZESQL-MAAS-I.EZEI-25 , :EZESQL-MAAS-H.EZEI-26:EZESQL-MAAS-I.EZEI-26 , :EZESQL-MAAS-H.EZEI-27:EZESQL-MAAS-I.EZEI-27 , :EZESQL-MAAS-H.EZEI-28:EZESQL-MAAS-I.EZEI-28 , :EZESQL-MAAS-H.EZEI-29:EZESQL-MAAS-I.EZEI-29 , :EZESQL-MAAS-H.KAMP:EZESQL-MAAS-I.KAMP , :EZESQL-MAAS-H.YEMEK:EZESQL-MAAS-I.YEMEK , :EZESQL-MAAS-H.LOKAL:EZESQL-MAAS-I.LOKAL , :EZESQL-MAAS-H.KRES:EZESQL-MAAS-I.KRES , :EZESQL-MAAS-H.ICRA:EZESQL-MAAS-I.ICRA , :EZESQL-MAAS-H.HARCIRAH:EZESQL-MAAS-I.HARCIRAH , :EZESQL-MAAS-H.EZEI-30:EZESQL-MAAS-I.EZEI-30 , :EZESQL-MAAS-H.EZEI-31:EZESQL-MAAS-I.EZEI-31 ) END-EXEC MOVE "INSERT" TO EZERTS-SQL-COMMAND PERFORM EZESQL-ERROR-ROUTINE MOVE EZERTS-SQLERR-STATUS TO EZESTA-MAAS-RC CONTINUE. EZEADD-MAAS-ADD-ERR. IF EZESTA-MAAS-ERR SET EZERTS-EZECLOS TO TRUE GO TO EZETERMINATE END-IF CONTINUE. EZEADD-MAAS-ADD-X. EXIT. *----------------------------------------------------------------- * INPUT / OUTPUT ROUTINE FOR PROCESS MAAS_REP1 *----------------------------------------------------------------- * PROCESS OPTION : REPLACE * PROCESS OBJECT : MAAS *----------------------------------------------------------------- EZEREPL-MAAS-REP1 SECTION. MOVE "MAAS_REP1" TO EZERTS-PRC-NAME MOVE "REPLACE" TO EZERTS-PRC-OPT MOVE "MAAS" TO EZERTS-PRC-OBJ SET EZERTS-NO-ERROR-ROUTINE TO TRUE MOVE ZEROES TO EZESTA-MAAS-RC IF EZECRS-MAAS-CLOS OR EZECRS-MAAS-SETI OR EZECRS-MAAS-SIWH MOVE 0086 TO EZERTS-ERROR-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-ERROR-REQUEST-BLOCK GO TO EZETERMINATE END-IF IF EZECRS-MAAS-ID = 1 EXEC SQL UPDATE BORDRO.MAAS SET SICIL = :EZESQL-MAAS-H.SICIL:EZESQL-MAAS-I.SICIL , ESKI_DERECE = :EZESQL-MAAS-H.EZEI-1:EZESQL-MAAS-I.EZEI-1 , ESKI_KADEME = :EZESQL-MAAS-H.EZEI-2:EZESQL-MAAS-I.EZEI-2 , ESKI_EKGOSTERGE = :EZESQL-MAAS-H.EZEI-3:EZESQL-MAAS-I.EZEI-3 , ESKI_KIDEM = :EZESQL-MAAS-H.EZEI-4:EZESQL-MAAS-I.EZEI-4 , DERECE = :EZESQL-MAAS-H.DERECE:EZESQL-MAAS-I.DERECE , KADEME = :EZESQL-MAAS-H.KADEME:EZESQL-MAAS-I.KADEME , EKGOSTERGE = :EZESQL-MAAS-H.EKGOSTERGE:EZESQL-MAAS-I.EKGOSTERGE , KIDEM = :EZESQL-MAAS-H.KIDEM:EZESQL-MAAS-I.KIDEM , IS_GUC_PUAN = :EZESQL-MAAS-H.EZEI-5:EZESQL-MAAS-I.EZEI-5 , IS_GUCLUGU = :EZESQL-MAAS-H.EZEI-6:EZESQL-MAAS-I.EZEI-6 , ELTEM_PUAN = :EZESQL-MAAS-H.EZEI-7:EZESQL-MAAS-I.EZEI-7 , ELTEM_GUCLUGU = :EZESQL-MAAS-H.EZEI-8:EZESQL-MAAS-I.EZEI-8 , ELTEM_PUAN = :EZESQL-MAAS-H.EZEI-9:EZESQL-MAAS-I.EZEI-9 , ELTEM_GUCLUGU = :EZESQL-MAAS-H.EZEI-10:EZESQL-MAAS-I.EZEI-10 , MAKAM_PUAN = :EZESQL-MAAS-H.EZEI-11:EZESQL-MAAS-I.EZEI-11 , MAKAM_TAZ = :EZESQL-MAAS-H.EZEI-12:EZESQL-MAAS-I.EZEI-12 , MALI_SOR_PUAN = :EZESQL-MAAS-H.EZEI-13:EZESQL-MAAS-I.EZEI-13 , MALI_SORUMLULUK_TAZ = :EZESQL-MAAS-H.EZEI-14:EZESQL-MAAS-I.EZEI-14 , YABANCI_DIL_SEVIYE = :EZESQL-MAAS-H.EZEI-15:EZESQL-MAAS-I.EZEI-15 , YABANCI_DIL_TAZ = :EZESQL-MAAS-H.EZEI-16:EZESQL-MAAS-I.EZEI-16 , LOJMAN_TAZ = :EZESQL-MAAS-H.EZEI-17:EZESQL-MAAS-I.EZEI-17 , AILE_YARDIM_PUAN = :EZESQL-MAAS-H.EZEI-18:EZESQL-MAAS-I.EZEI-18 , AILE_YARDIM_TAZ = :EZESQL-MAAS-H.EZEI-19:EZESQL-MAAS-I.EZEI-19 , COCUK_SAYI = :EZESQL-MAAS-H.EZEI-20:EZESQL-MAAS-I.EZEI-20 , COCUK_TAZ = :EZESQL-MAAS-H.EZEI-21:EZESQL-MAAS-I.EZEI-21 , VAKIF_AIDAT = :EZESQL-MAAS-H.EZEI-27:EZESQL-MAAS-I.EZEI-27 , SAGLIK_AIDAT = :EZESQL-MAAS-H.EZEI-28:EZESQL-MAAS-I.EZEI-28 , VAKIF_KREDI = :EZESQL-MAAS-H.EZEI-29:EZESQL-MAAS-I.EZEI-29 , KAMP = :EZESQL-MAAS-H.KAMP:EZESQL-MAAS-I.KAMP , YEMEK = :EZESQL-MAAS-H.YEMEK:EZESQL-MAAS-I.YEMEK , LOKAL = :EZESQL-MAAS-H.LOKAL:EZESQL-MAAS-I.LOKAL , KRES = :EZESQL-MAAS-H.KRES:EZESQL-MAAS-I.KRES , ICRA = :EZESQL-MAAS-H.ICRA:EZESQL-MAAS-I.ICRA , HARCIRAH = :EZESQL-MAAS-H.HARCIRAH:EZESQL-MAAS-I.HARCIRAH , NET_MAAS = :EZESQL-MAAS-H.EZEI-30:EZESQL-MAAS-I.EZEI-30 , TOP_MATRAH = :EZESQL-MAAS-H.EZEI-31:EZESQL-MAAS-I.EZEI-31 WHERE CURRENT OF EZE001001MGGSM1 END-EXEC END-IF MOVE "UPDATE" TO EZERTS-SQL-COMMAND PERFORM EZESQL-ERROR-ROUTINE MOVE EZERTS-SQLERR-STATUS TO EZESTA-MAAS-RC IF EZECRS-MAAS-UPDT PERFORM EZECLOSCU-MAAS END-IF. EZEREPL-MAAS-REP1-ERR. IF EZESTA-MAAS-ERR SET EZERTS-EZECLOS TO TRUE GO TO EZETERMINATE END-IF CONTINUE. EZEREPL-MAAS-REP1-X. EXIT. *----------------------------------------------------------------- * INPUT / OUTPUT ROUTINE FOR PROCESS MAAS_UPD1 *----------------------------------------------------------------- * PROCESS OPTION : UPDATE * PROCESS OBJECT : MAAS *----------------------------------------------------------------- EZEUPDT-MAAS-UPD1 SECTION. MOVE "MAAS_UPD1" TO EZERTS-PRC-NAME MOVE "UPDATE" TO EZERTS-PRC-OPT MOVE "MAAS" TO EZERTS-PRC-OBJ SET EZERTS-NO-ERROR-ROUTINE TO TRUE MOVE ZEROES TO EZESTA-MAAS-RC IF NOT EZECRS-MAAS-CLOS PERFORM EZECLOSCU-MAAS IF EZESTA-MAAS-HRD GO TO EZEUPD-MAAS-UPD1-ERR END-IF END-IF EXEC SQL OPEN EZE001001MGGSM1 END-EXEC MOVE "OPEN" TO EZERTS-SQL-COMMAND PERFORM EZESQL-ERROR-ROUTINE MOVE EZERTS-SQLERR-STATUS TO EZESTA-MAAS-RC IF EZESTA-MAAS-HRD OR EZESTA-MAAS-NRF GO TO EZEUPD-MAAS-UPD1-ERR END-IF MOVE 1 TO EZECRS-MAAS-ID MOVE "UPDT" TO EZECRS-MAAS-TYP EXEC SQL FETCH EZE001001MGGSM1 INTO :EZESQL-MAAS-H.EZEI-1:EZESQL-MAAS-I.EZEI-1 , :EZESQL-MAAS-H.EZEI-2:EZESQL-MAAS-I.EZEI-2 , :EZESQL-MAAS-H.EZEI-3:EZESQL-MAAS-I.EZEI-3 , :EZESQL-MAAS-H.EZEI-4:EZESQL-MAAS-I.EZEI-4 , :EZESQL-MAAS-H.DERECE:EZESQL-MAAS-I.DERECE , :EZESQL-MAAS-H.KADEME:EZESQL-MAAS-I.KADEME , :EZESQL-MAAS-H.EKGOSTERGE:EZESQL-MAAS-I.EKGOSTERGE , :EZESQL-MAAS-H.KIDEM:EZESQL-MAAS-I.KIDEM , :EZESQL-MAAS-H.EZEI-5:EZESQL-MAAS-I.EZEI-5 , :EZESQL-MAAS-H.EZEI-6:EZESQL-MAAS-I.EZEI-6 , :EZESQL-MAAS-H.EZEI-7:EZESQL-MAAS-I.EZEI-7 , :EZESQL-MAAS-H.EZEI-8:EZESQL-MAAS-I.EZEI-8 , :EZESQL-MAAS-H.EZEI-9:EZESQL-MAAS-I.EZEI-9 , :EZESQL-MAAS-H.EZEI-10:EZESQL-MAAS-I.EZEI-10 , :EZESQL-MAAS-H.EZEI-11:EZESQL-MAAS-I.EZEI-11 , :EZESQL-MAAS-H.EZEI-12:EZESQL-MAAS-I.EZEI-12 , :EZESQL-MAAS-H.EZEI-13:EZESQL-MAAS-I.EZEI-13 , :EZESQL-MAAS-H.EZEI-14:EZESQL-MAAS-I.EZEI-14 , :EZESQL-MAAS-H.EZEI-15:EZESQL-MAAS-I.EZEI-15 , :EZESQL-MAAS-H.EZEI-16:EZESQL-MAAS-I.EZEI-16 , :EZESQL-MAAS-H.EZEI-17:EZESQL-MAAS-I.EZEI-17 , :EZESQL-MAAS-H.EZEI-18:EZESQL-MAAS-I.EZEI-18 , :EZESQL-MAAS-H.EZEI-19:EZESQL-MAAS-I.EZEI-19 , :EZESQL-MAAS-H.EZEI-20:EZESQL-MAAS-I.EZEI-20 , :EZESQL-MAAS-H.EZEI-21:EZESQL-MAAS-I.EZEI-21 , :EZESQL-MAAS-H.EZEI-22:EZESQL-MAAS-I.EZEI-22 , :EZESQL-MAAS-H.EZEI-23:EZESQL-MAAS-I.EZEI-23 , :EZESQL-MAAS-H.EZEI-24:EZESQL-MAAS-I.EZEI-24 , :EZESQL-MAAS-H.EZEI-25:EZESQL-MAAS-I.EZEI-25 , :EZESQL-MAAS-H.EZEI-26:EZESQL-MAAS-I.EZEI-26 , :EZESQL-MAAS-H.EZEI-27:EZESQL-MAAS-I.EZEI-27 , :EZESQL-MAAS-H.EZEI-28:EZESQL-MAAS-I.EZEI-28 , :EZESQL-MAAS-H.EZEI-29:EZESQL-MAAS-I.EZEI-29 , :EZESQL-MAAS-H.KAMP:EZESQL-MAAS-I.KAMP , :EZESQL-MAAS-H.YEMEK:EZESQL-MAAS-I.YEMEK , :EZESQL-MAAS-H.LOKAL:EZESQL-MAAS-I.LOKAL , :EZESQL-MAAS-H.KRES:EZESQL-MAAS-I.KRES , :EZESQL-MAAS-H.ICRA:EZESQL-MAAS-I.ICRA , :EZESQL-MAAS-H.HARCIRAH:EZESQL-MAAS-I.HARCIRAH , :EZESQL-MAAS-H.EZEI-30:EZESQL-MAAS-I.EZEI-30 , :EZESQL-MAAS-H.EZEI-31:EZESQL-MAAS-I.EZEI-31 END-EXEC MOVE "FETCH" TO EZERTS-SQL-COMMAND PERFORM EZESQL-ERROR-ROUTINE MOVE EZERTS-SQLERR-STATUS TO EZESTA-MAAS-RC IF EZESTA-MAAS-HRD OR EZESTA-MAAS-NRF PERFORM EZECLOSCU-MAAS GO TO EZEUPD-MAAS-UPD1-ERR END-IF IF EZEI-1 OF EZESQL-MAAS-I NEGATIVE MOVE SPACES TO EZEI-1 OF MAAS END-IF IF EZEI-2 OF EZESQL-MAAS-I NEGATIVE MOVE SPACES TO EZEI-2 OF MAAS END-IF IF EZEI-3 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-3 OF MAAS END-IF IF EZEI-4 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-4 OF MAAS END-IF IF DERECE OF EZESQL-MAAS-I NEGATIVE MOVE SPACES TO DERECE OF MAAS END-IF IF KADEME OF EZESQL-MAAS-I NEGATIVE MOVE SPACES TO KADEME OF MAAS END-IF IF EKGOSTERGE OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EKGOSTERGE OF MAAS END-IF IF KIDEM OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO KIDEM OF MAAS END-IF IF EZEI-5 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-5 OF MAAS END-IF IF EZEI-6 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-6 OF MAAS END-IF IF EZEI-7 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-7 OF MAAS END-IF IF EZEI-8 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-8 OF MAAS END-IF IF EZEI-9 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-9 OF MAAS END-IF IF EZEI-10 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-10 OF MAAS END-IF IF EZEI-11 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-11 OF MAAS END-IF IF EZEI-12 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-12 OF MAAS END-IF IF EZEI-13 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-13 OF MAAS END-IF IF EZEI-14 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-14 OF MAAS END-IF IF EZEI-15 OF EZESQL-MAAS-I NEGATIVE MOVE SPACES TO EZEI-15 OF MAAS END-IF IF EZEI-16 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-16 OF MAAS END-IF IF EZEI-17 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-17 OF MAAS END-IF IF EZEI-18 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-18 OF MAAS END-IF IF EZEI-19 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-19 OF MAAS END-IF IF EZEI-20 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-20 OF MAAS END-IF IF EZEI-21 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-21 OF MAAS END-IF IF EZEI-22 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-22 OF MAAS END-IF IF EZEI-23 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-23 OF MAAS END-IF IF EZEI-24 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-24 OF MAAS END-IF IF EZEI-25 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-25 OF MAAS END-IF IF EZEI-26 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-26 OF MAAS END-IF IF EZEI-27 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-27 OF MAAS END-IF IF EZEI-28 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-28 OF MAAS END-IF IF EZEI-29 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-29 OF MAAS END-IF IF KAMP OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO KAMP OF MAAS END-IF IF YEMEK OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO YEMEK OF MAAS END-IF IF LOKAL OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO LOKAL OF MAAS END-IF IF KRES OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO KRES OF MAAS END-IF IF ICRA OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO ICRA OF MAAS END-IF IF HARCIRAH OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO HARCIRAH OF MAAS END-IF IF EZEI-30 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-30 OF MAAS END-IF IF EZEI-31 OF EZESQL-MAAS-I NEGATIVE MOVE ZERO TO EZEI-31 OF MAAS END-IF CONTINUE. EZEUPD-MAAS-UPD1-ERR. IF EZESTA-MAAS-ERR SET EZERTS-EZECLOS TO TRUE GO TO EZETERMINATE END-IF CONTINUE. EZEUPDT-MAAS-UPD1-X. EXIT. *----------------------------------------------------------------- * MAIN PROCESS : MGGSM1-MAIN * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:29:38 * PROCESS OPTION : EXECUTE *----------------------------------------------------------------- MGGSM1-MAIN SECTION. MOVE "MGGSM1-MAIN" TO EZERTS-PRC-NAME 000001* /* Standard initialization for atomic database operations. 000002* PERFORM SQL-INIT; PERFORM EZEP-SQL-INIT 000003* 000004* /* Initialize Access Type (R=read, W=write). 000005* VDBCONTROL.UACCTYP = 'W'; MOVE "W" TO UACCTYP OF VDBCONTROL 000006* 000007* /* Store application name 000008* VDBCOMMON.UAPPLNAM = 'MGGSM1'; MOVE "MGGSM1" TO UAPPLNAM OF VDBCOMMON 000009* 000010* /* Store the name of the SQL record in the server common record. 000011* VDBCOMMON.USQLREC = 'MAAS'; MOVE "MAAS" TO USQLREC OF VDBCOMMON 000012* VDBCOMMON.UTABLNAM = "Maas Bilgileri"; MOVE "Maas Bilgileri" TO UTABLNAM OF VDBCOMMON 000013* 000014* /* Check if record already exists. 000015* MAAS.SICIL = WMAAS.SICIL; MOVE SICIL OF WMAAS TO SICIL OF MAAS MOVE ZEROS TO SICIL OF EZESQL-MAAS-I 000016* PERFORM MAAS_UPD1; PERFORM MAAS-UPD1 000017* /* If record does not exist. 000018* IF MAAS IS NRF; IF EZESTA-MAAS-NRF GO TO EZECONDLBL-1 END-IF GO TO EZECONDLBL-2 CONTINUE. EZECONDLBL-1. 000019* /* Insert new record in table 000020* IF VDBCONTROL.UIOTYPE EQ "I"; IF UIOTYPE OF VDBCONTROL = "I" GO TO EZECONDLBL-3 END-IF GO TO EZECONDLBL-4 CONTINUE. EZECONDLBL-3. 000021* PERFORM MGGSM1-INSERT; PERFORM MGGSM1-INSERT CONTINUE. EZECONDLBL-4. 000022* END; 000023* ELSE; /* Record does exist. GO TO EZECONDLBL-5 CONTINUE. EZECONDLBL-2. 000024* IF MAAS NOT ERR; IF NOT EZESTA-MAAS-ERR GO TO EZECONDLBL-6 END-IF GO TO EZECONDLBL-7 CONTINUE. EZECONDLBL-6. 000025* IF VDBCONTROL.UIOTYPE NE "I"; IF UIOTYPE OF VDBCONTROL NOT = "I" GO TO EZECONDLBL-8 END-IF GO TO EZECONDLBL-9 CONTINUE. EZECONDLBL-8. 000026* 000027* /* Update record in table 000028* IF VDBCONTROL.UIOTYPE EQ "U"; IF UIOTYPE OF VDBCONTROL = "U" GO TO EZECONDLBL-10 END-IF GO TO EZECONDLBL-11 CONTINUE. EZECONDLBL-10. 000029* /* Replace the record in the table 000030* PERFORM MGGSM1-REPLACE; PERFORM MGGSM1-REPLACE 000031* ELSE; GO TO EZECONDLBL-12 CONTINUE. EZECONDLBL-11. 000032* /* Delete record from table 000033* IF VDBCONTROL.UIOTYPE EQ "D"; IF UIOTYPE OF VDBCONTROL = "D" GO TO EZECONDLBL-13 END-IF GO TO EZECONDLBL-14 CONTINUE. EZECONDLBL-13. 000034* /* Remove data from table 000035* PERFORM MGGSM1-DELETE; PERFORM MGGSM1-DELETE CONTINUE. EZECONDLBL-14. 000036* END; CONTINUE. EZECONDLBL-12. 000037* END; 000038* ELSE; /* Record exists: duplicate key 000038* error GO TO EZECONDLBL-15 CONTINUE. EZECONDLBL-9. 000039* VMESSAGE.UMSGCODE = 'SQL0803'; MOVE "SQL0803" TO UMSGCODE OF VMESSAGE 000040* VDBCONTROL.URC = 1; MOVE 1 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) CONTINUE. EZECONDLBL-15. 000041* END; CONTINUE. EZECONDLBL-7. 000042* END; CONTINUE. EZECONDLBL-5. 000043* END; 000044* 000045* /* Standard error handling for atomic database operations. 000046* PERFORM SQL-ERROR; PERFORM EZEP-SQL-ERROR CONTINUE. EZE-MGGSM1-MAIN-X. EXIT. *----------------------------------------------------------------- * STRUCTURE LIST POST-PROCESSING *----------------------------------------------------------------- EZESTRUCTURE-FALLTHRU SECTION. GO TO EZETERMINATE. EZESTRUCTURE-FALLTHRU-X. EXIT. *----------------------------------------------------------------- * PROCESS : MAAS-DEL * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:29:20 * PROCESS OPTION : DELETE * PROCESS OBJECT : MAAS *----------------------------------------------------------------- MAAS-DEL SECTION. MOVE "MAAS-DEL" TO EZERTS-PRC-NAME PERFORM EZEDELT-MAAS-DEL CONTINUE. EZE-MAAS-DEL-X. EXIT. *----------------------------------------------------------------- * PROCESS : MAAS_ADD * : MAAS_ADD RENAMED TO MAAS-ADD * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:24:44 * PROCESS OPTION : ADD * PROCESS OBJECT : MAAS *----------------------------------------------------------------- MAAS-ADD SECTION. MOVE "MAAS_ADD" TO EZERTS-PRC-NAME PERFORM EZEADD-MAAS-ADD CONTINUE. EZE-MAAS-ADD-X. EXIT. *----------------------------------------------------------------- * PROCESS : MAAS_REP1 * : MAAS_REP1 RENAMED TO MAAS-REP1 * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:27:05 * PROCESS OPTION : REPLACE * PROCESS OBJECT : MAAS *----------------------------------------------------------------- MAAS-REP1 SECTION. MOVE "MAAS_REP1" TO EZERTS-PRC-NAME PERFORM EZEREPL-MAAS-REP1 CONTINUE. EZE-MAAS-REP1-X. EXIT. *----------------------------------------------------------------- * PROCESS : MAAS_UPD1 * : MAAS_UPD1 RENAMED TO MAAS-UPD1 * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:23:29 * PROCESS OPTION : UPDATE * PROCESS OBJECT : MAAS *----------------------------------------------------------------- MAAS-UPD1 SECTION. MOVE "MAAS_UPD1" TO EZERTS-PRC-NAME PERFORM EZEUPDT-MAAS-UPD1 CONTINUE. EZE-MAAS-UPD1-X. EXIT. *----------------------------------------------------------------- * PROCESS : MGGSM1-DELETE * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:29:23 * PROCESS OPTION : EXECUTE *----------------------------------------------------------------- MGGSM1-DELETE SECTION. MOVE "MGGSM1-DELETE" TO EZERTS-PRC-NAME 000059* /* Call process to delete row from table. 000060* PERFORM MAAS-DEL; PERFORM MAAS-DEL 000061* 000062* /* Set error flags. 000063* /* UNRF - no record found flag (Y,N,1) 000064* /* UDUP - duplicate key flag (Y,N) 000065* VDBCOMMON.UNRF = 'Y'; MOVE "Y" TO UNRF OF VDBCOMMON 000066* VDBCOMMON.UDUP = 'N'; MOVE "N" TO UDUP OF VDBCOMMON CONTINUE. EZE-MGGSM1-DELETE-X. EXIT. *----------------------------------------------------------------- * PROCESS : MGGSM1-INSERT * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:25:11 * PROCESS OPTION : EXECUTE *----------------------------------------------------------------- MGGSM1-INSERT SECTION. MOVE "MGGSM1-INSERT" TO EZERTS-PRC-NAME 000067* PERFORM MGGSM1-MOVEDATA; PERFORM MGGSM1-MOVEDATA 000068* /* Set error flags. 000069* /* UNRF - no record found flag (Y,N,1) 000070* /* UDUP - duplicate key flag (Y,N) 000071* VDBCOMMON.UNRF = 'N'; MOVE "N" TO UNRF OF VDBCOMMON 000072* VDBCOMMON.UDUP = 'Y'; MOVE "Y" TO UDUP OF VDBCOMMON 000073* PERFORM MAAS_ADD; PERFORM MAAS-ADD CONTINUE. EZE-MGGSM1-INSERT-X. EXIT. *----------------------------------------------------------------- * PROCESS : MGGSM1-MOVEDATA * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:25:07 * PROCESS OPTION : EXECUTE *----------------------------------------------------------------- MGGSM1-MOVEDATA SECTION. MOVE "MGGSM1-MOVEDATA" TO EZERTS-PRC-NAME 000074* MAAS = WMAAS; MOVE SICIL OF WMAAS TO SICIL OF MAAS MOVE ZEROS TO SICIL OF EZESQL-MAAS-I MOVE ESKI-DERECE OF WMAAS TO EZEI-1 OF MAAS MOVE ZEROS TO EZEI-1 OF EZESQL-MAAS-I MOVE ESKI-KADEME OF WMAAS TO EZEI-2 OF MAAS MOVE ZEROS TO EZEI-2 OF EZESQL-MAAS-I MOVE ESKI-EKGOSTERGE OF WMAAS TO EZEI-3 OF MAAS MOVE ZEROS TO EZEI-3 OF EZESQL-MAAS-I MOVE ESKI-KIDEM OF WMAAS TO EZEI-4 OF MAAS MOVE ZEROS TO EZEI-4 OF EZESQL-MAAS-I MOVE DERECE OF WMAAS TO DERECE OF MAAS MOVE ZEROS TO DERECE OF EZESQL-MAAS-I MOVE KADEME OF WMAAS TO KADEME OF MAAS MOVE ZEROS TO KADEME OF EZESQL-MAAS-I MOVE EKGOSTERGE OF WMAAS TO EKGOSTERGE OF MAAS MOVE ZEROS TO EKGOSTERGE OF EZESQL-MAAS-I MOVE KIDEM OF WMAAS TO KIDEM OF MAAS MOVE ZEROS TO KIDEM OF EZESQL-MAAS-I MOVE IS-GUC-PUAN OF WMAAS TO EZEI-5 OF MAAS MOVE ZEROS TO EZEI-5 OF EZESQL-MAAS-I MOVE IS-GUCLUGU OF WMAAS TO EZEI-6 OF MAAS MOVE ZEROS TO EZEI-6 OF EZESQL-MAAS-I MOVE ELTEM-PUAN OF WMAAS TO EZEI-7 OF MAAS MOVE ZEROS TO EZEI-7 OF EZESQL-MAAS-I MOVE ELTEM-GUCLUGU OF WMAAS TO EZEI-8 OF MAAS MOVE ZEROS TO EZEI-8 OF EZESQL-MAAS-I MOVE OZEL-HIZMET-YZD OF WMAAS TO EZEI-9 OF MAAS MOVE ZEROS TO EZEI-9 OF EZESQL-MAAS-I MOVE OZEL-HIZMET-TAZ OF WMAAS TO EZEI-10 OF MAAS MOVE ZEROS TO EZEI-10 OF EZESQL-MAAS-I MOVE MAKAM-PUAN OF WMAAS TO EZEI-11 OF MAAS MOVE ZEROS TO EZEI-11 OF EZESQL-MAAS-I MOVE MAKAM-TAZ OF WMAAS TO EZEI-12 OF MAAS MOVE ZEROS TO EZEI-12 OF EZESQL-MAAS-I MOVE MALI-SOR-PUAN OF WMAAS TO EZEI-13 OF MAAS MOVE ZEROS TO EZEI-13 OF EZESQL-MAAS-I MOVE MALI-SORUMLULUK-TAZ OF WMAAS TO EZEI-14 OF MAAS MOVE ZEROS TO EZEI-14 OF EZESQL-MAAS-I MOVE YABANCI-DIL-SEVIYE OF WMAAS TO EZEI-15 OF MAAS MOVE ZEROS TO EZEI-15 OF EZESQL-MAAS-I MOVE YABANCI-DIL-TAZ OF WMAAS TO EZEI-16 OF MAAS MOVE ZEROS TO EZEI-16 OF EZESQL-MAAS-I MOVE LOJMAN-TAZ OF WMAAS TO EZEI-17 OF MAAS MOVE ZEROS TO EZEI-17 OF EZESQL-MAAS-I MOVE AILE-YARDIM-PUAN OF WMAAS TO EZEI-18 OF MAAS MOVE ZEROS TO EZEI-18 OF EZESQL-MAAS-I MOVE AILE-YARDIM-TAZ OF WMAAS TO EZEI-19 OF MAAS MOVE ZEROS TO EZEI-19 OF EZESQL-MAAS-I MOVE COCUK-SAYI OF WMAAS TO EZEI-20 OF MAAS MOVE ZEROS TO EZEI-20 OF EZESQL-MAAS-I MOVE COCUK-TAZ OF WMAAS TO EZEI-21 OF MAAS MOVE ZEROS TO EZEI-21 OF EZESQL-MAAS-I MOVE GELIR-VERGI OF WMAAS TO EZEI-22 OF MAAS MOVE ZEROS TO EZEI-22 OF EZESQL-MAAS-I MOVE DAMGA-VERGI OF WMAAS TO EZEI-23 OF MAAS MOVE ZEROS TO EZEI-23 OF EZESQL-MAAS-I MOVE YUKSELIS-KES OF WMAAS TO EZEI-24 OF MAAS MOVE ZEROS TO EZEI-24 OF EZESQL-MAAS-I MOVE EMEKLI-AIDAT-SAH OF WMAAS TO EZEI-25 OF MAAS MOVE ZEROS TO EZEI-25 OF EZESQL-MAAS-I MOVE EMEKLI-AIDAT-KUR OF WMAAS TO EZEI-26 OF MAAS MOVE ZEROS TO EZEI-26 OF EZESQL-MAAS-I MOVE VAKIF-AIDAT OF WMAAS TO EZEI-27 OF MAAS MOVE ZEROS TO EZEI-27 OF EZESQL-MAAS-I MOVE SAGLIK-AIDAT OF WMAAS TO EZEI-28 OF MAAS MOVE ZEROS TO EZEI-28 OF EZESQL-MAAS-I MOVE VAKIF-KREDI OF WMAAS TO EZEI-29 OF MAAS MOVE ZEROS TO EZEI-29 OF EZESQL-MAAS-I MOVE KAMP OF WMAAS TO KAMP OF MAAS MOVE ZEROS TO KAMP OF EZESQL-MAAS-I MOVE YEMEK OF WMAAS TO YEMEK OF MAAS MOVE ZEROS TO YEMEK OF EZESQL-MAAS-I MOVE LOKAL OF WMAAS TO LOKAL OF MAAS MOVE ZEROS TO LOKAL OF EZESQL-MAAS-I MOVE KRES OF WMAAS TO KRES OF MAAS MOVE ZEROS TO KRES OF EZESQL-MAAS-I MOVE ICRA OF WMAAS TO ICRA OF MAAS MOVE ZEROS TO ICRA OF EZESQL-MAAS-I MOVE HARCIRAH OF WMAAS TO HARCIRAH OF MAAS MOVE ZEROS TO HARCIRAH OF EZESQL-MAAS-I MOVE NET-MAAS OF WMAAS TO EZEI-30 OF MAAS MOVE ZEROS TO EZEI-30 OF EZESQL-MAAS-I MOVE TOP-MATRAH OF WMAAS TO EZEI-31 OF MAAS MOVE ZEROS TO EZEI-31 OF EZESQL-MAAS-I CONTINUE. EZE-MGGSM1-MOVEDATA-X. EXIT. *----------------------------------------------------------------- * PROCESS : MGGSM1-REPLACE * MODIFICATION DATE : 02.06.2000 * MODIFICATION TIME : 16:27:08 * PROCESS OPTION : EXECUTE *----------------------------------------------------------------- MGGSM1-REPLACE SECTION. MOVE "MGGSM1-REPLACE" TO EZERTS-PRC-NAME 000075* /* Copy the data to the SQL record 000076* PERFORM MGGSM1-MOVEDATA; PERFORM MGGSM1-MOVEDATA 000077* /* Replace the row in the table 000078* PERFORM MAAS_REP1; PERFORM MAAS-REP1 000079* 000080* /* Set error flags. 000081* /* UNRF - no record found vlag (Y,N,1) 000082* /* UDUP - duplicate key vlag (Y,N) 000083* VDBCOMMON.UNRF = 'N'; MOVE "N" TO UNRF OF VDBCOMMON 000084* VDBCOMMON.UDUP = 'Y'; MOVE "Y" TO UDUP OF VDBCOMMON CONTINUE. EZE-MGGSM1-REPLACE-X. EXIT. *----------------------------------------------------------------- * PROCESS : SQL-ERROR * : SQL-ERROR RENAMED TO EZEP-SQL-ERROR * MODIFICATION DATE : 01.06.2000 * MODIFICATION TIME : 10:43:35 * PROCESS OPTION : EXECUTE * DESCRIPTION : std. SQL error handler *----------------------------------------------------------------- EZEP-SQL-ERROR SECTION. MOVE "SQL-ERROR" TO EZERTS-PRC-NAME 000085* /* *********************************************************** 000086* /* * Process : SQL-ERROR 000087* /* * 000088* /* * Function : Reusable standard SQL error handling process. 000089* /* * 000090* /* ************************************************************ 000091* /* ----------------------------------------------------------- 000092* /* This process handles SQL errors. Depending on the values 000093* /* in EZESQLCOD, VDBCONTROL.URC and the UNRF and UDUP flags, 000094* /* the need of a ROLLBACK is required. 000095* /* 000096* /* ROLLBACK in only necessary when action type is 000097* /* UACCTYP = 'W'. Both COMMIT and ROLLBACK will have to 000098* /* be issued from the calling application (umbrella). 000099* /* 000100* /* Condition UNRF UDUP URC Commit or Rollback 000101* /* ========= ==== ==== === ================== 000102* /* EZESQCOD=0 * * 0 COMMIT 000103* /* EZESQCOD=100 Y * 100 ROLLBACK 000104* /* EZESQCOD=100 N * 0 COMMIT 000105* /* EZESQCOD=100 1 * 100 ROLLBACK (if UROWR = 0) 000106* /* 0 COMMIT (if UROWR > 0) 000107* /* EZESQCOD=-803 * Y 104 ROLLBACK 000108* /* EZESQCOD=-803 * N 0 COMMIT 000109* /* EZESQCOD=-911 * * 108 ROLLBACK 000110* /* other SQL error * * 112 ROLLBACK 000111* 000112* /* In case an SQL error occurred: 000113* IF EZESQCOD NE 0 000114* AND VDBCONTROL.URC EQ 0; IF EZESQCOD NOT = 0 AND URC OF VDBCONTROL = 0 000115* 000116* /* No Record Found error (NRF) 000117* IF EZESQCOD EQ 100; IF EZESQCOD = 100 000118* IF VDBCONTROL.UIOTYPE EQ "D"; IF UIOTYPE OF VDBCONTROL = "D" 000119* /* Delete failed: row not found 000120* VMESSAGE.UMSGCODE = 'SQL0100D'; MOVE "SQL0100D" TO UMSGCODE OF VMESSAGE 000121* VDBCONTROL.URC = 1; MOVE 1 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000122* ELSE; ELSE 000123* IF VDBCONTROL.UIOTYPE EQ "U"; IF UIOTYPE OF VDBCONTROL = "U" 000124* /* Update failed: row not found 000125* VMESSAGE.UMSGCODE = 'SQL0100U'; MOVE "SQL0100U" TO UMSGCODE OF VMESSAGE 000126* VDBCONTROL.URC = 1; MOVE 1 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000127* ELSE; ELSE 000128* IF VDBCOMMON.UNRF EQ 'Y'; IF UNRF OF VDBCOMMON = "Y" 000129* /* Read failed: row not found 000130* VDBCONTROL.URC = 100; MOVE 100 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000131* VMESSAGE.UMSGCODE = 'SQL0100'; MOVE "SQL0100" TO UMSGCODE OF VMESSAGE 000132* ELSE; ELSE 000133* IF VDBCOMMON.UNRF EQ '1'; IF UNRF OF VDBCOMMON = "1" 000134* IF VDBCONTROL.UROWR EQ 0; IF UROWR OF VDBCONTROL = 0 000135* /* No rows read: NRF error 000136* VDBCONTROL.URC = 100; MOVE 100 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000137* VMESSAGE.UMSGCODE = 'SQL0100'; MOVE "SQL0100" TO UMSGCODE OF VMESSAGE 000138* END; END-IF 000139* END; END-IF 000140* END; END-IF 000141* END; END-IF 000142* END; END-IF 000143* ELSE; /* Other errors ELSE 000144* /* duplicate key error (DUP) 000145* IF EZESQCOD EQ -803; IF EZESQCOD = -803 000146* IF VDBCOMMON.UDUP EQ 'Y'; IF UDUP OF VDBCOMMON = "Y" 000147* VDBCONTROL.URC = 104; MOVE 104 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000148* VMESSAGE.UMSGCODE = 'SQL0803'; MOVE "SQL0803" TO UMSGCODE OF VMESSAGE 000149* END; END-IF 000150* ELSE; ELSE 000151* /* deadlock/timeout error 000152* IF EZESQCOD EQ -911 000153* OR EZESQCOD EQ -913; IF EZESQCOD = -911 OR EZESQCOD = -913 000154* VDBCONTROL.URC = 108; MOVE 108 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000155* VMESSAGE.UMSGCODE = 'SQL0913'; MOVE "SQL0913" TO UMSGCODE OF VMESSAGE 000156* ELSE; ELSE 000157* IF EZESQCOD EQ -532; IF EZESQCOD = -532 000158* VDBCONTROL.URC = 108; MOVE 108 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000159* VMESSAGE.UMSGCODE = 'SQL0532'; MOVE "SQL0532" TO UMSGCODE OF VMESSAGE 000160* ELSE; ELSE 000161* IF EZESQCOD EQ -530; IF EZESQCOD = -530 000162* VDBCONTROL.URC = 108; MOVE 108 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000163* VMESSAGE.UMSGCODE = 'SQL0530'; MOVE "SQL0530" TO UMSGCODE OF VMESSAGE 000164* ELSE; ELSE 000165* /* Other SQL error 000166* IF EZESQCOD LT 0; IF EZESQCOD < 0 000167* VDBCONTROL.URC = 112; MOVE 112 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000168* VMESSAGE.UMSGCODE = 'SQL9999'; MOVE "SQL9999" TO UMSGCODE OF VMESSAGE 000169* END; END-IF 000170* END; END-IF 000171* END; END-IF 000172* END; /* deadlock/timeout error END-IF 000173* END; /* DUP error END-IF 000174* END; /* NRF error END-IF 000175* 000176* /* When URC contains a value, move the EZESQCOD 000177* /* to the message insert field. 000178* IF VDBCONTROL.URC EQ 112 000179* OR VDBCONTROL.URC EQ 108; IF URC OF VDBCONTROL = 112 OR URC OF VDBCONTROL = 108 000180* 000181* /* Move SQL error number to number item. 000182* VDBCOMMON.USQLNUM = EZESQCOD; COMPUTE USQLNUM OF VDBCOMMON = EZESQCOD ON SIZE ERROR MOVE "SQL-ERROR" TO EZERTS-PRC-NAME MOVE 182 TO EZERTS-PRC-NUM PERFORM EZEOVER-ROUTINE END-COMPUTE CALL "ELAFXNUM" USING USQLNUM OF VDBCOMMON(LENGTH OF USQLNUM OF VDBCOMMON:1) 000183* 000184* /* Set SQL code sign. 000185* IF VDBCOMMON.USQLNUM LT 0; IF USQLNUM OF VDBCOMMON < 0 000186* VDBCOMMON.USIGN = '-'; MOVE "-" TO USIGN OF VDBCOMMON 000187* VDBCOMMON.USQLNUM = VDBCOMMON.USQLNUM * -1; COMPUTE USQLNUM OF VDBCOMMON = USQLNUM OF VDBCOMMON * -1 ON SIZE ERROR MOVE "SQL-ERROR" TO EZERTS-PRC-NAME MOVE 187 TO EZERTS-PRC-NUM PERFORM EZEOVER-ROUTINE END-COMPUTE CALL "ELAFXNUM" USING USQLNUM OF VDBCOMMON(LENGTH OF USQLNUM OF VDBCOMMON:1) 000188* ELSE; ELSE 000189* VDBCOMMON.USIGN = '+'; MOVE "+" TO USIGN OF VDBCOMMON 000190* END; /* Set SQL code sign. END-IF 000191* 000192* /* Move SQL error number to character item. 000193* VDBCOMMON.USQLCHA = VDBCOMMON.USQLNUM; MOVE USQLNUM OF VDBCOMMON(1:LENGTH OF USQLNUM OF VDBCOMMON) TO USQLCHA OF VDBCOMMON 000194* 000195* /* Move SQL error number to message insert. 000196* VMESSAGE.UMSGINS(1) = VDBCOMMON.UEZESQCD; MOVE UEZESQCD OF VDBCOMMON TO UMSGINS OF VMESSAGE (1) 000197* 000198* END; END-IF 000199* END; /* SQL error occurred. END-IF 000200* 000201* 000202* /* When error occurred: 000203* IF VDBCONTROL.URC NE 0; IF URC OF VDBCONTROL NOT = 0 000204* 000205* /* Store SQL message inserts. 000206* VDBCONTROL.UEZESQRRM = EZESQRRM; MOVE EZESQRRM TO UEZESQRRM OF VDBCONTROL 000207* 000208* /* Move applicationame to message insert. 000209* IF VMESSAGE.UMSGINS(1) EQ ' '; IF UMSGINS OF VMESSAGE (1) = " " 000210* VMESSAGE.UMSGINS(1) = VDBCOMMON.UPROCNAM; MOVE UPROCNAM OF VDBCOMMON TO UMSGINS OF VMESSAGE (1) 000211* END; END-IF 000212* 000213* /* Move applicationame to message insert. 000214* IF VMESSAGE.UMSGINS(2) EQ ' '; IF UMSGINS OF VMESSAGE (2) = " " 000215* VMESSAGE.UMSGINS(2) = VDBCOMMON.UAPPLNAM; MOVE UAPPLNAM OF VDBCOMMON TO UMSGINS OF VMESSAGE (2) 000216* END; END-IF 000217* 000218* /* Move tablename to message insert. 000219* IF VMESSAGE.UMSGINS(3) EQ ' '; IF UMSGINS OF VMESSAGE (3) = " " 000220* VMESSAGE.UMSGINS(3) = VDBCOMMON.UTABLNAM; MOVE UTABLNAM OF VDBCOMMON TO UMSGINS OF VMESSAGE (3) 000221* END; END-IF 000222* 000223* /* Determine if rollback is required 000224* IF VDBCONTROL.UACCTYP EQ 'W' 000225* AND VDBCONTROL.UROWW GE 1; IF UACCTYP OF VDBCONTROL = "W" AND UROWW OF VDBCONTROL >= 1 000226* VDBCONTROL.UROLLBACK = 'Y'; MOVE "Y" TO UROLLBACK OF VDBCONTROL 000227* END; /* Rollback required. END-IF 000228* END; /* Error detected. END-IF CONTINUE. EZE-EZEP-SQL-ERROR-X. EXIT. *----------------------------------------------------------------- * PROCESS : SQL-INIT * : SQL-INIT RENAMED TO EZEP-SQL-INIT * MODIFICATION DATE : 01.06.2000 * MODIFICATION TIME : 10:44:07 * PROCESS OPTION : EXECUTE * DESCRIPTION : std. SQL initialization *----------------------------------------------------------------- EZEP-SQL-INIT SECTION. MOVE "SQL-INIT" TO EZERTS-PRC-NAME 000229* /* ************************************************************ 000230* /* * Proces : SQL-INIT 000231* /* * 000232* /* * Function : This process initializes the record items 000233* /* * used in applications which perform SQL 000234* /* * queries. 000235* /* * 000236* /* ************************************************************ 000237* 000238* /* Return SQL hard errors. 000239* EZEFEC = 1; MOVE 1 TO EZEFEC CALL "ELAFXNUM" USING EZEFEC(LENGTH OF EZEFEC:1) 000240* 000241* /* Initialize common data items used for control 000242* /* and error handling. 000243* VDBCONTROL.URC = 0; MOVE 0 TO URC OF VDBCONTROL CALL "ELAFXNUM" USING URC OF VDBCONTROL(LENGTH OF URC OF VDBCONTROL:1) 000244* VDBCONTROL.UROLLBACK = 'N'; MOVE "N" TO UROLLBACK OF VDBCONTROL 000245* VDBCONTROL.UNRF = 'N'; MOVE "N" TO UNRF OF VDBCONTROL 000246* 000247* VDBCONTROL.UACCTYP = ' '; MOVE " " TO UACCTYP OF VDBCONTROL 000248* VDBCONTROL.UACCSAV = ' '; MOVE " " TO UACCSAV OF VDBCONTROL 000249* VDBCONTROL.UROWR = 0; MOVE 0 TO UROWR OF VDBCONTROL 000250* VDBCONTROL.UROWW = 0; MOVE 0 TO UROWW OF VDBCONTROL 000251* VDBCONTROL.UEZESQRRM = ' '; MOVE " " TO UEZESQRRM OF VDBCONTROL 000252* 000253* SET VDBCOMMON EMPTY; PERFORM EZESETEMP-VDBCOMMON 000254* 000255* LOW-VALUE = ' '; MOVE " " TO EZEI-LOW-VALUE OF VDBCONTROL 000256* IF EZESYS IS ITF; IF EZESYS-ITF 000257* HIGH-VALUE = 'Z'; MOVE "Z" TO EZEI-HIGH-VALUE OF VDBCONTROL 000258* ELSE; ELSE 000259* HIGH-VALUE = '9'; MOVE "9" TO EZEI-HIGH-VALUE OF VDBCONTROL 000260* END; END-IF 000261* CONTINUE. EZE-EZEP-SQL-INIT-X. EXIT. *----------------------------------------------------------------- * SQL ERROR ROUTINE *----------------------------------------------------------------- EZESQL-ERROR-ROUTINE SECTION. SET EZERTS-SQL-USED TO TRUE IF EZERTS-SQL-COMMAND NOT = "CLOSE" MOVE SQLCA TO EZESQLCA END-IF IF SQLCODE = 0 MOVE 0 TO EZERTS-SQLERR-STATUS ELSE MOVE EZERTS-SQLERR TO EZERTS-SQLERR-SVCS-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-SQLERR-REQUEST-BLOCK SQLCA IF EZERTS-TERMINATE AND EZECTL-NOT-IN-EZETERMINATE GO TO EZETERMINATE END-IF END-IF. EZESQL-ERROR-ROUTINE-X. EXIT. *----------------------------------------------------------------- * SET EMPTY FOR RECORD MAAS *----------------------------------------------------------------- EZESETEMP-MAAS SECTION. MOVE LOW-VALUES TO MAAS OF EZESTA-MAAS-GP MOVE SPACES TO SICIL OF MAAS MOVE SPACES TO EZEI-1 OF MAAS MOVE SPACES TO EZEI-2 OF MAAS MOVE SPACES TO DERECE OF MAAS MOVE SPACES TO KADEME OF MAAS MOVE 0 TO EZEI-6 OF MAAS MOVE 0 TO EZEI-8 OF MAAS MOVE 0 TO EZEI-10 OF MAAS MOVE 0 TO EZEI-12 OF MAAS MOVE 0 TO EZEI-14 OF MAAS MOVE SPACES TO EZEI-15 OF MAAS MOVE 0 TO EZEI-16 OF MAAS MOVE 0 TO EZEI-17 OF MAAS MOVE 0 TO EZEI-19 OF MAAS MOVE 0 TO EZEI-21 OF MAAS MOVE 0 TO EZEI-22 OF MAAS MOVE 0 TO EZEI-23 OF MAAS MOVE 0 TO EZEI-24 OF MAAS MOVE 0 TO EZEI-25 OF MAAS MOVE 0 TO EZEI-26 OF MAAS MOVE 0 TO EZEI-27 OF MAAS MOVE 0 TO EZEI-28 OF MAAS MOVE 0 TO EZEI-29 OF MAAS MOVE 0 TO KAMP OF MAAS MOVE 0 TO YEMEK OF MAAS MOVE 0 TO LOKAL OF MAAS MOVE 0 TO KRES OF MAAS MOVE 0 TO ICRA OF MAAS MOVE 0 TO HARCIRAH OF MAAS MOVE 0 TO EZEI-30 OF MAAS MOVE 0 TO EZEI-31 OF MAAS CONTINUE. EZESETEMP-MAAS-X. EXIT. *----------------------------------------------------------------- * SET EMPTY FOR RECORD VDBCOMMON *----------------------------------------------------------------- EZESETEMP-VDBCOMMON SECTION. INITIALIZE VDBCOMMON OF EZEWS-VDBCOMMON-GP MOVE SPACES TO USYSID1 OF VDBCOMMON MOVE SPACES TO UAPPLID OF VDBCOMMON MOVE SPACES TO UAPPLSFX OF VDBCOMMON CALL "ELAFXNUM" USING USQLNUM OF VDBCOMMON(LENGTH OF USQLNUM OF VDBCOMMON:1) MOVE SPACES TO USIGN OF VDBCOMMON MOVE SPACES TO USQLCHA OF VDBCOMMON CONTINUE. EZESETEMP-VDBCOMMON-X. EXIT. *----------------------------------------------------------------- * TERMINATION LOGIC *----------------------------------------------------------------- EZETERMINATE SECTION. SET EZECTL-IN-EZETERMINATE TO TRUE. MOVE "EZETERMINATE" TO EZERTS-PRC-NAME PERFORM EZERESRC-SCHEDULE GO TO EZERUN-PROCESSES-X. *----------------------------------------------------------------- * ARITHMETIC OVERFLOW ROUTINE *----------------------------------------------------------------- EZEOVER-ROUTINE SECTION. MOVE 1 TO EZEOVERS IF EZEOVER-TERMINATE MOVE 0009 TO EZERTS-ERROR-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-ERROR-REQUEST-BLOCK GO TO EZETERMINATE END-IF. EZEOVER-ROUTINE-X. EXIT. *----------------------------------------------------------------- * MAXIMUM VALUE OVERFLOW ROUTINE *----------------------------------------------------------------- EZEOVER-MAX-VALUE-ROUTINE SECTION. MOVE 1 TO EZEOVERS IF EZEOVER-DEFAULT OR EZEOVER-TERMINATE MOVE 0026 TO EZERTS-ERROR-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-ERROR-REQUEST-BLOCK GO TO EZETERMINATE END-IF. EZEOVER-MAX-VALUE-ROUTINE-X. EXIT. *----------------------------------------------------------------- * CALLED APPLICATION CONTROL LOGIC *----------------------------------------------------------------- EZECONTROL SECTION. MOVE EIBFN TO EZEAPP-ENTRY-FUNCTION EXEC CICS IGNORE CONDITION ERROR END-EXEC CALL "ELARSTWA" USING DFHEIBLK DFHCOMMAREA EZEAPP-PROFILE SET ADDRESS OF EZERTS-CONTROL-BLOCK TO EZEAPP-RTS-PTR EXEC CICS HANDLE ABEND PROGRAM("ELAESABD") END-EXEC SET EZEPARM-MAPS-INVALID TO TRUE IF NOT EZERTS-SET MOVE "EZEINITIALIZE" TO EZERTS-PRC-NAME MOVE EZEAPP-APPL-NAME TO EZERTS-PGM-NAME SET EZEAPP-CALLER-PROFILE TO NULL CALL "ELAASADR" USING EZEAPP-PROFILE EZERTS-INIT-PROFILE ELSE MOVE "EZEINITIALIZE" TO EZERTS-PRC-NAME MOVE EZERTS-PGM-NAME TO EZECALLER MOVE EZEAPP-APPL-NAME TO EZERTS-PGM-NAME SET EZEAPP-CALLER-PROFILE TO EZERTS-CURR-PROFILE MOVE EZEDLPSB TO EZECTL-HOLD-EZEDLPSB IF EZERTS-TERMINATE CALL "ELAASADR" USING EZEAPP-PROFILE EZERTS-CURR-PROFILE SET EZECTL-IN-EZETERMINATE TO TRUE PERFORM EZEAPPL-IDENTIFY PERFORM EZEEXTERNAL-INITIALIZATION PERFORM EZERESRC-CLEANUP SET EZERTS-CURR-PROFILE TO EZEAPP-CALLER-PROFILE MOVE EZECALLER TO EZERTS-PGM-NAME GO TO EZECONTROL-X END-IF END-IF MOVE EZERTS-CTL-MODE TO EZECTL-HOLD-CTL-MODE MOVE EZERTS-CTL-REQUEST TO EZECTL-HOLD-CTL-REQUEST MOVE EZESEGTR TO EZESEGTR-SAVE MOVE SPACES TO EZESEGTR PERFORM EZEAPPL-IDENTIFY PERFORM EZEINITIALIZE-STORAGE PERFORM EZEREFRESH-STORAGE IF NOT EZERTS-TERMINATE-ON-ERROR AND EZEAPP-ENTRY-FUNCTION NOT = X"0E04" AND NOT EZERTS-ENTRY-FROM-TSMODULE PERFORM EZERECEIVE-COMMAREA-PARMS END-IF IF NOT EZERTS-TERMINATE-ON-ERROR PERFORM EZEEXTERNAL-INITIALIZATION END-IF IF NOT EZERTS-TERMINATE-ON-ERROR PERFORM EZERUN-PROCESSES END-IF IF EZEAPP-CALLER-PROFILE = NULL OR EZEAPP-ENTRY-FUNCTION = X"0E04" OR EZERTS-ENTRY-FROM-TSMODULE SET EZEAPP-CALLER-PROFILE TO NULL IF EZERTS-TERMINATE-ON-ERROR PERFORM EZEREPORT-ERRS-ON-TERMINATN END-IF PERFORM EZECICS-RTS-TERMINATE ELSE SET EZERTS-CURR-PROFILE TO EZEAPP-CALLER-PROFILE MOVE EZECALLER TO EZERTS-PGM-NAME MOVE EZESEGTR-SAVE TO EZESEGTR IF NOT EZERTS-TERMINATE MOVE EZECTL-HOLD-CTL-MODE TO EZERTS-CTL-MODE MOVE EZECTL-HOLD-CTL-REQUEST TO EZERTS-CTL-REQUEST END-IF MOVE EZECTL-HOLD-EZEDLPSB TO EZEDLPSB END-IF. EZECONTROL-X. EXIT. *----------------------------------------------------------------- * IDENTIFY APPLICATION *----------------------------------------------------------------- EZEAPPL-IDENTIFY SECTION. IF NOT EZERTS-SET MOVE SPACES TO EZELTERM MOVE ALL "*" TO EZEUSR EZEUSRID END-IF SET EZEAPP-CURS-BLK-PTR TO NULL SET EZEAPP-LAST-MAPBUF-PTR TO NULL SET EZEAPP-FIRST-MAPBUF-PTR TO NULL SET EZEAPP-ROWS-USED-PTR TO NULL SET EZEAPP-MAPG-MOD-PTR TO NULL SET EZEAPP-HELPG-MOD-PTR TO NULL CALL "ELAASADR" USING EZEWORDS EZEAPP-EZE-WORDS-PTR CALL "ELAASADR" USING EZEPARM-VALIDATION EZEAPP-PARM-VAL-PTR CALL "ELAASADR" USING EZEAPP-PROFILE EZERTS-CURR-PROFILE. EZEAPPL-IDENTIFY-X. EXIT. *----------------------------------------------------------------- * INITIALIZE STORAGE *----------------------------------------------------------------- EZEINITIALIZE-STORAGE SECTION. MOVE SPACES TO EZEWORDS-I MOVE ZERO TO EZECNVCM MOVE ZERO TO EZEFEC EZERCODE MOVE ZERO TO EZEDLERR EZESQISL EZEOVER EZEOVERS MOVE SPACES TO EZEDLPSB IF EZESEGTR = LOW-VALUES MOVE EIBTRNID TO EZESEGTR END-IF MOVE EIBTRMID TO EZELTERM EZEUSR SET EZESEGM-DEFINED TO TRUE MOVE SPACES TO EZEDESTP MOVE "N" TO EZEAPP-EZEDESTP-DIFF MOVE "N" TO EZEAPP-EZEDESTP-CHANGED MOVE 0 TO EZESTA-MAAS-RC PERFORM EZESETEMP-MAAS PERFORM EZESETEMP-VDBCOMMON CONTINUE. EZEINITIALIZE-STORAGE-X. EXIT. *----------------------------------------------------------------- * REFRESH STORAGE - ONLY THESE FIELDS ARE RESET ACROSS CONVERSE *----------------------------------------------------------------- EZEREFRESH-STORAGE SECTION. MOVE ZERO TO EZEDLCER EZEDLCON MOVE ZERO TO EZETST EZEDLLEV EZEDLSSG MOVE ZERO TO EZEMNO EZEDLKYL MOVE SPACES TO EZEDLSTC EZEDLDBD EZEDLKEY EZEDLPRO EZEDLSEG MOVE SPACES TO EZEMSG OF EZEWORDS MOVE "N" TO EZEMNO-MSG-FILE-SW MOVE LOW-VALUES TO EZESQLCA MOVE "SQLCA" TO EZESQNAM MOVE +136 TO EZESQABC MOVE ZERO TO EZESQCOD EZESQRRL MOVE ZERO TO EZESQRD1 EZESQRD2 EZESQRD3 MOVE ZERO TO EZESQRD4 EZESQRD5 EZESQRD6 IF NOT EZERTS-SET OR NOT EZERTS-TERMINATE MOVE SPACES TO EZERTS-DXFR-APPLID SET EZERTS-XFER-MAP-PTR TO NULL SET EZERTS-DXFR-XFER-REC-PTR TO NULL MOVE ZERO TO EZERTS-DXFR-XFER-REC-LEN END-IF. EZEREFRESH-STORAGE-X. EXIT. *----------------------------------------------------------------- * RTS INITIALIZATION *----------------------------------------------------------------- EZEEXTERNAL-INITIALIZATION SECTION. CALL "ELARSINT" USING EZERTS-CONTROL-BLOCK IF EZERTS-TERMINATE-ON-ERROR AND EZECTL-NOT-IN-EZETERMINATE GO TO EZEEXTERNAL-INITIALIZATION-X END-IF SET ADDRESS OF EZEIOP-NLS-INDEP-CTL-BLOCK TO EZERTS-IOP-TABLE-PTR SET ADDRESS OF EZEIOE-NLS-DEP-CTL-BLOCK TO EZERTS-DOP-TABLE-PTR SET ADDRESS OF EZECRS-CURSOR-BLOCKS TO EZEAPP-CURS-BLK-PTR IF NOT EZERTS-TERMINATE SET EZERTS-EXECUTE TO TRUE END-IF. EZEEXTERNAL-INITIALIZATION-X. EXIT. *----------------------------------------------------------------- * RUN APPLICATION PROCESSES *----------------------------------------------------------------- EZERUN-PROCESSES SECTION. SET EZECTL-NOT-IN-EZETERMINATE TO TRUE GO TO EZEBEGIN-PROCESSES. EZERUN-PROCESSES-X. EXIT. *----------------------------------------------------------------- * REPORT THE ERRORS *----------------------------------------------------------------- EZEREPORT-ERRS-ON-TERMINATN SECTION. IF NOT EZERTS-ROLLBACK-TAKEN SET EZERTS-ROLLBACK-TAKEN TO TRUE MOVE EZERTS-ROLLBACK TO EZERTS-SVCS-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-REQUEST-BLOCK END-IF IF EZERTS-TERMINAL-ATTACHED MOVE EZERTS-DISPLAY-ERROR-MAP TO EZERTS-SVCS-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-REQUEST-BLOCK END-IF CONTINUE. EZEREPORT-ERRS-ON-TERMINATN-X. EXIT. *----------------------------------------------------------------- * RECEIVE PARAMETERS THAT WERE PASSED IN THE COMMAREA *----------------------------------------------------------------- EZERECEIVE-COMMAREA-PARMS SECTION. IF EIBCALEN < 4 OR (DFHCOMMAREA(EIBCALEN - 3:4) = HIGH-VALUES AND EIBCALEN NOT = 16) OR (DFHCOMMAREA(EIBCALEN - 3:4) NOT = HIGH-VALUES AND EIBCALEN NOT = 12) IF NOT EZERTS-SET CALL "ELARSINT" USING EZERTS-CONTROL-BLOCK END-IF IF NOT EZERTS-TERMINATE MOVE 32 TO EZERTS-ERROR-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-ERROR-REQUEST-BLOCK END-IF GO TO EZERECEIVE-COMMAREA-PARMS-X END-IF SET ADDRESS OF EZERCD-WMAAS-GP TO EZECOMMAREA-PTR(1) SET ADDRESS OF EZERCD-VDBCONTROL-GP TO EZECOMMAREA-PTR(2) SET ADDRESS OF EZERCD-VMESSAGE-GP TO EZECOMMAREA-PTR(3) CONTINUE. EZERECEIVE-COMMAREA-PARMS-X. EXIT. *----------------------------------------------------------------- * CANCEL CLEAN-UP IF ALL RESOURCES ARE CLOSED *----------------------------------------------------------------- EZERESRC-SCHEDULE SECTION. MOVE "EZERESRC-SCHED" TO EZERTS-PRC-NAME IF EZEAPP-CALLER-PROFILE IS EQUAL TO NULL PERFORM EZERESRC-CLEANUP GO TO EZERESRC-SCHEDULE-X END-IF IF EZECRS-MAAS-CLOS MOVE EZERTS-UNSCHEDULE TO EZERTS-SVCS-NUM CALL "ELARSVCS" USING EZERTS-CONTROL-BLOCK EZERTS-REQUEST-BLOCK END-IF CONTINUE. EZERESRC-SCHEDULE-X. EXIT. *----------------------------------------------------------------- * RESOURCE CLEAN-UP ROUTINE *----------------------------------------------------------------- EZERESRC-CLEANUP SECTION. SET EZECTL-IN-EZETERMINATE TO TRUE MOVE "EZERESRC-CLEAN" TO EZERTS-PRC-NAME PERFORM EZERESRC-CLOSE-CURSORS CONTINUE. EZERESRC-CLEANUP-X. EXIT. *----------------------------------------------------------------- * RESOURCE CLEAN-UP / CLOSE ALL OPEN CURSORS *----------------------------------------------------------------- EZERESRC-CLOSE-CURSORS SECTION. IF NOT EZECRS-MAAS-CLOS PERFORM EZECLOSCU-MAAS END-IF CONTINUE. EZERESRC-CLOSE-CURSORS-X. EXIT. EZECICS-RTS-TERMINATE SECTION. CALL "ELAASTRM" USING EZERTS-CONTROL-BLOCK EZERTS-REQUEST-BLOCK EXEC CICS HANDLE ABEND CANCEL END-EXEC. EZECICS-RTS-TERMINATE-X. EXIT. *----------------------------------------------------------------- * END OF PROGRAM MGGSM1 *-----------------------------------------------------------------